Microsoft Office Tutorials and References
In Depth Information
Figure 19-21: Using conditional formatting to highlight cells with invalid entries.
Working with Conditional Formats
This section describes some additional information about conditional formatting that you may find useful.
The Conditional Formatting Rules Manager dialog box is useful for checking, editing, deleting, and adding con-
ditional formats. First select any cell in the range that contains conditional formatting. Then choose
Home ⇒ Styles ⇒ Conditional Formatting ⇒ Manage Rules.
You can specify as many rules as you like by clicking the New Rule button. As you can see in Figure 19-22,
cells can even use data bars, color scales, and icon sets all at the same time — although I can't think of a good
reason to do so.