Microsoft Office Tutorials and References
In Depth Information
Making your own rules
FIGURE 19.12
One of several different conditional formatting dialog boxes
The formatting suggestions in the drop-down list are just a few of thousands of different
formatting combinations. If none of Excel’s suggestions are what you want, choose the
Custom Format option to display the Format Cells dialog box. You can specify the format in
any or all of the four tabs: Number, Font, Border, and Fill.
The Format Cells dialog box used for conditional formatting is a modii ed version of the standard Format Cells dialog
box. It doesn’t have the Alignment and Protection tabs, and some of the Font formatting options are disabled. The
dialog box also includes a Clear button that clears any formatting already selected.
Making your own rules
For maximum control, Excel provides the New Formatting Rule dialog box, shown
in Figure 19.13. Access this dialog box by choosing Home Styles Conditional
New Rules.
FIGURE 19.13
Use the New Formatting Rule dialog box to create your own conditional formatting rules.
Search JabSto ::

Custom Search