Manage conditional formatting rules in Excel

You can see all the conditional formatting rules in a workbook using the tool Conditional Formatting Rules Manager (Conditional Formatting Rules Manager). It can also be used to create, edit, and delete rules.

1. Highlight a cell A1.
2. On the Advanced tab Mainth (Home) select a team Conditional Formatting > Rule management (Conditional Formatting > Manage Rules).The Conditional Formatting Rules Manager (Conditional Formatting Rules Manager).

   

Note: Because the cell is selected A1, Excel displays the rules that apply to the range A1: A10.

3. To see all conditional formatting rules on this sheet, select from the drop down list Show formatting rules for (Show formating rules for) пункт This sheet (This Worksheet).

Note: Нажмите кнопку Create Rule (New Rule), Change the rule (Edit Rule) or Delete rule (Delete Rule) to create, edit, and delete a rule, respectively.