Microsoft Office Tutorials and References
In Depth Information
Creating conditional formatting formulas
You can use two commands on the Find & Select menu on the Home tab to locate cells on
the current worksheet that conditional formats are applied to. The Conditional Formatting
command locates and selects all the cells on the current worksheet to which conditional
formats are applied. If conditional formatting exists in more than one cell region on the
worksheet, using this command selects all the regions. This makes it easy to edit all the
rules using the Conditional Formatting Rules Manager dialog box (shown earlier in Figure
9-28). You can also use the Go To Special command on the Find & Select menu to get a
little more specific. Clicking this command displays the Go To Special dialog box, shown in
Figure 9-30.
Figure 9-30 Use the Go To Special dialog box to locate all conditional formats or just matching
ones.
When you select the Conditional Formats option, two additional options—All and Same—
become available. Selecting All is the same as using the Conditional Formatting command
on the Find & Select menu to select all conditionally formatted cells and regions. If you use
the Same option, however, Go To Special finds only cells that are formatted using the same
condition that exists in the selected cell. Before clicking the Go To Special command, select
a cell containing the conditional format you want to locate.
Creating conditional formatting formulas
The last rule type in the New Formatting Rule dialog box shown in Figure 9-26 offers the
ability to create your own conditional formatting formulas. When you select the rule type
labeled Use A Formula To Determine Which Cells To Format, the dialog box looks similar to
the one shown in Figure 9-31.
Search JabSto ::




Custom Search