Managing Conditional Formatting in Excel 2007

In today’s post, we are now going to look at how to manage our conditional formatting rules. The Conditional Formatting Rules Manager dialog box allows you to create new rules, edit, delete or change the order of existing rules, and stop evaluation of the rules in your list at a specific rule. The rules in the Conditional Formatting Rules Manager dialog box are executed in the order that they are listed. If you find that two rules are in conflict, changing the order may solve your issue.

To Manage Conditional Formatting

1. Select the cell range with the conditional formatting you wish to manage.
2. Click the Home tab on the Ribbon.
3. Click the Conditional Formatting button on the Home Ribbon and click Manage Rules to display the Conditional Formatting Rules Manager dialog box.
4. Click the rule you wish to modify.
5. To move a rule, click the Move Up or Move Down arrow.
6. To delete the selected rule, click the Delete Rule button
7. To edit the selected rule, click the Edit Rule button and make your changes. Click OK when finished.
8. To stop executing your rules at a specific rule, click the Stop if True check box at the rule where you wish evaluation to stop.
9. When finished, click OK.

Similar Posts:

• Using Conditional Formatting in Excel 2007
• Creating Your Own Conditional Formatting Rules in Excel 2007
• Using Conditional Formatting based on Top/Bottom Values in Excel 2007
• Using Rules in Outlook 2007
• Managing Range Names in Excel
• Applying Specialized Conditional Formatting in Excel 2007
• Backup your Rules in Outlook 2007

Tagged as: Excel, Microsoft Office Tips