Solved

# How do I change this rule formula for conditional formatting in Excel 2007 to include an OR statement?

Posted on 2016-07-22

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.