Page 199 - Excel 2013 All-in-One For Dummies

Figure 2-23:
Define
a new conditional formatting rule using the options in the New Formatting Rule dialog box.
Conditional Formatting 181
Managing conditional formatting rules
The Conditional Formatting Rules Manager dialog box, which you open by choosing the Manage Rules option at the very bottom of the Conditional Formatting button’s drop-down menu, enables you to do all of the following:
✦ Create new rules by clicking the New Rule button to open the New Formatting Rule dialog box. (See the “Creating your own conditional for- matting rules” section immediately preceding.)
✦ Edit existing rules by selecting the rule in the Rule list box and clicking the Edit Rule button in the Editing Formatting Rule dialog box (which looks just like the New Formatting Rule dialog box except it contains the rule type, criteria, and formatting for the particular rule you selected).
✦ Delete rules by clicking the rule in the Rule list box and then clicking the Delete Rule button — click the Apply button to remove formatting from the worksheet that was applied to the rule you just deleted.
✦ Change the order of precedence in which multiple conditional format- ting rules assigned to the same cell selection or table are applied by pro- moting or demoting individual rules in the Rule list box by clicking the rules and then clicking either the Move Up button (with the thick arrow pointing upward) or Move Down button (with the thick arrow pointing downward) until the rules appear in the desired order of precedence.
Book II Chapter 2
Formatting Worksheets