Microsoft Office Tutorials and References
In Depth Information
Managing conditional formatting rules
Figure 9-27 Use the second rule type in the New Formatting Rule dialog box to create your own
highlight cells rules.
Use the Edit The Rule Description area to define your formats. This area changes
depending on the rule selected. With Format Only Cells That Contain selected, the first drop-down
list in this area (shown in Figure 9-27) allows you to define rules for highlighting Cell Value,
Specific Text, Dates Occurring (relative to now), Blanks, No Blanks, Errors, or No Errors.
Then select an operator (Between, Not Between, Equal To, Not Equal To, Greater Than, Less
Than, Greater Than Or Equal To, Less Than Or Equal To) and type comparison values in the
remaining text boxes.
After you establish the rule description criteria, click the Format button. An abbreviated
version of the Format Cells dialog box appears, containing only Number, Font, Border, and
Fill tabs. Specify any combination of formats you want to apply when your rule is triggered.
When you finish, click OK to return to the New Formatting Rule dialog box, and click OK
again to save your new rule. You can create as many rules as you want; next, we’ll discuss
how to work with them.
Managing conditional formatting rules
You can apply as many conditional formats as you think are necessary—using three or
more per table is not uncommon. But it is also not uncommon for you to tweak some of
the numbers or adjust some of the formatting. To do so, click Home, Conditional
Formatting, Manage Rules to display a Conditional Formatting Rules Manager dialog box similar
to the one shown in Figure 9-28.
Search JabSto ::

Custom Search