Microsoft Office Tutorials and References
In Depth Information
Changing the appearance of data
With the Conditional Formatting Rules Manager, you can 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
clicking OK .
Save any new rules without closing the Conditional Formatting Rules Manager by
clicking Apply .
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.
After you create a rule, you can change the format applied if the rule is true by clicking the
rule and then clicking the Edit Rule button to display the Edit Formatting Rule dialog box.
Search JabSto ::




Custom Search