The Conditional Formatting Rules Manager dialog allows you to add, edit, or delete conditional formatting rules.
The Show formatting rules for option allows you to choose Current Selection or This WorkSheet. You can use the up and down arrows to move up and down the rule list.
| Button | Description |
|---|---|
| New Rule | Click the New Rule button to display the dialog for adding new rules. |
| Edit Rule | Click the Edit Rule button to edit an existing rule. |
| Delete Rule | Click the Delete Rule button to delete the currently selected rule. |
| OK | Click this button to accept the changes. |
| Close | Click this button to close the dialog. |
| Apply | Click this button to apply the changes. |
| Column | Description |
|---|---|
| Rule | The Rule column displays the type of rule. |
| Format | The format displays the format applied to the cell. |
| Applies to | The Applies to column displays the cell or cell range that the rule applies to. |
| Stop If True | The Stop If True column determines whether to ignore any rules applied to the cell after this rule. The rules are always processed in the specific order shown in the Conditional Formatting Rules Manager dialog for the cell or range. |
The following image displays the dialog for adding new rules.
This image displays multiple rules that have been created with the rules manager.
