Microsoft Office Tutorials and References
In Depth Information
When you select which kind of condition to create, Excel displays a dialog box that contains
fields and controls you can use to define your rule. To display all of the rules for the selected
cells, display the Home tab, and then in the Styles group, click Conditional Formatting. On
the menu, click Manage Rules to display the Conditional Formatting Rules Manager.
The Conditional Formatting Rules Manager enables you to control your conditional formats
in the following ways:
● Create a new rule by clicking the New Rule button.
● Change a rule by clicking the rule and then clicking the Edit Rule button.
● Remove a rule by clicking the rule and then clicking the Delete Rule button.
● Move a rule up or down in the order by clicking the rule and then clicking the
Move Up button or Move Down button.
● Control whether Excel continues evaluating conditional formats after it finds a rule
to apply by selecting or clearing a rule’s Stop If True check box.
● Save any new rules and close the Conditional Formatting Rules Manager by
● Save any new rules without closing the Conditional Formatting Rules Manager by
● Discard any unsaved changes by clicking Cancel.
Tip Clicking the New Rule button in the Conditional Formatting Rules Manager opens the
New Formatting Rule dialog box. The commands in the New Formatting Rule dialog box
duplicate the options displayed when you click the Conditional Formatting button in the
Styles group on the Home tab.