Combining conditional formatting rules

**geopiet** · 11-16-2010, 09:57 PM

In attached sample I have separate conditional rules for each week, that means two (2) of each color.

Right now working rules are as below;

=IF($B$2="Blue",COUNTIF(Blue,B$7)) applies to =$B$6:$H$10

=IF($B$2="Blue",COUNTIF(Blue,B$12)) applies to =$B$11:$H$15

When I try to combine them in following manner they cease to work;

=IF($B$2="Blue",COUNTIF(Blue,B$7:B$12)) applies to =$B$6:$H$10,$B$11:$H$15

What am I doing wrong?

**SDruley** · 11-16-2010, 10:20 PM

I am having some trouble opening your file.
My experience with conditional formatting has guided me to create simple expressions that will result in either a true or false condition. The format of the cell is then engaged when the expression results in the desired boolean property.
most of these expressions are not associated with the IF statement. A very common expression is as follows =(F8>6)