Microsoft Office Tutorials and References
In Depth Information
Highlighting Trends and Variations in Data
Conditional formats don’t behave as expected.
If the formats you see in a table aren’t displayed as you expected, you should check
several possible causes. If you experimented with multiple rules, it’s possible that you
left an old set of rules in place and added a new, conflicting rule that applies to the
same data. To check for this possibility, open the Conditional Formatting Rules
Manager dialog box and choose This Worksheet from the Show Formatting Rules For list.
If you see an old, unnecessary rule, select it and click Delete Rule. It’s also possible you
have a conflict between multiple rules, with the rule at the top of the list applying one
set of formatting that is then overruled by a later rule. If you want the first rule to take
primacy, select the Stop If True check box after that rule. Finally, check the numbers
used as triggers within each rule. Excel applies some default settings when you
create the rule. If your data has changed since then, you might need to tweak the rules
If you experiment a little too much with conditional formatting rules and want to get a
fresh start, click Clear Rules from the Conditional Formatting menu. You can erase the rules
from a selection, an entire sheet, a table, or a PivotTable.