Microsoft Office Tutorials and References
In Depth Information
Creating conditional formatting rules
Creating conditional formatting rules
Excel provides a nice variety of conditional formatting options, but you can always create
your own as well. You might have noticed the New Rule command at the bottom of the
Conditional Formatting menu and the ubiquitous More Rules command on each submenu.
These all do essentially the same task—display the New Formatting Rule dialog box shown
in Figure 9-26.
Figure 9-26 Use the New Formatting Rule dialog box to construct your own conditional formats.
All these commands open the same dialog box, but based on the menu or submenu where
you clicked the command, a different rule type is selected when it opens. Each rule type
displays a different set of rule-description criteria below it. To display the dialog box in
Figure 9-26, we clicked Conditional Formatting on the Home tab, then Icon Sets, and then the
More Rules command. Each format style has a different set of controls for creating
conditional formatting rules.
The first rule type—Format All Cells Based On Their Values—contains all the controls for
creating data bars, color scales, and icon sets. The rule description controls for the second
rule type—Format Only Cells That Contain, shown in Figure 9-27—is what you use to create
highlight cells rules. The controls for the remaining rule types are similar to this one.
We discuss the last rule type, Use A Formula To Determine Which Cells To Format, in “Creating
conditional formatting formulas” later in this chapter.
Search JabSto ::




Custom Search