Discussion on:

Message 7 of 22
0 Votes
+ -
Excel 2003
The formulas work fine in 2003.

In the conditional formatting box, for Condition 1, select "Formula Is" in the dropdown list, then enter the formula into the box to its right.

Remember to select the Patterns tab in the formatting options if you are trying to apply a color to the rows (its easy to mistakenly apply the formatting to the font, as that is the default tab).
Posted by charlac
21st Dec 2010