Microsoft Office Tutorials and References
In Depth Information
Managing conditional formatting rules
Figure 9-28 Use the Conditional Formatting Rules Manager dialog box to tweak any rules that
have been applied in a workbook.
You can use the Show Formatting Rules For drop-down list at the top of the dialog box
to choose where to look in the current workbook for rules: each worksheet in the
current workbook is listed here, or you can choose This Worksheet or Current Selection (the
default). As you can see in Figure 9-28, you can create, edit, and delete rules by using
corresponding buttons. When you click New Rule, the now-familiar New Formatting Rule
dialog box appears. When you click Edit Rule, a similar dialog box appears (Edit Formatting
Rule) with the criteria for the selected rule displayed.
Excel applies the rules listed in the Conditional Formatting Rules Manager dialog box in the
order in which they appear in the Rule list—new rules are added to the top of the list and
are processed first. Use the two arrow buttons next to Delete Rule to move a selected rule
up or down in the precedence list. The Applies To box contains the address of the cell range
to which the rule is applied. If you want to change the cell range, click the Collapse button
at the right end of the Applies To text box to collapse the dialog box, letting you see the
worksheet, as shown in Figure 9-29. When you do so, you can drag to select the cell range
you want and insert the range address in the text box. To restore the dialog box to its
original size, click the Collapse (now Expand) button again.
The Stop If True check box is present in this dialog box only for backward compatibility.
Previous versions of Excel cannot recognize multiple conditional formatting rules; instead,
they apply the rule that occurs last in precedence. If you need to share files with older
versions, you need to choose which conditional formatting rule you prefer. Select the Stop If
True check box for the last rule in the list if you want Excel to use the previous rule; select
the Stop If True check box for the last two rules to use the third-to-last rule, and so on.