How To Use Manage Rules In Excel

To view all conditional formatting rules in a workbook, use the Conditional Formatting Rules Manager. You can also use this screen to create, edit and delete rules.

1. Select cell A1.

Conditional Formatting Rule in Excel

2. On the Home tab, in the Styles group, click Conditional Formatting.

Click Conditional Formatting

3. Click Manage Rules.

Click Manage Rules

The Conditional Formatting Rules Manager appears.

Conditional Formatting Rules Manager

Note: because we selected cell A1, Excel shows the rule applied to the range A1:A10.

4. From the drop-down list, change Current Selection to This Worksheet, to view all conditional formatting rules in this worksheet.

Show formatting rules for This Worksheet

Note: click New Rule, Edit Rule and Delete Rule to create, edit and delete rules.