How do I change this rule formula for conditional formatting in Excel 2007 to include an OR statement?
This is my current formula (that works well):
=AND(min_rankning_1="bergsäker vinnare";Välj_rankningstabell="Min rankning")
min_rankning_1 is a named cell, referring to tab "LOPP 1" cell CD2567.
Välj_rankningstabell is a named cell, referring to tab "Reducerade system" cell H2.
This rule formula is entered in cell H5 on tab "Reducerade system".
What I need is to include OR, like this (although this syntax probably wouldn't work) so that more named cells are taken into account:
=AND(min_rankning_1 OR fackpressens_rankning_1 OR ATG:s_rankning_1="bergsäker vinnare";Välj_rankningstabell="Min rankning" OR "Fackpressens rankning" OR "ATG:s rankning")
By the way, for above conditional formatting rule, how long can it be? I need it to be much longer than above because I will include many more named cells.