Managing Conditional Formatting
You can create your own conditional formatting rules and editing any existing rules on the workbook.
Create a new rule
- Select the range of cells you wish to format with the new rule
- Click Conditional Formatting from the Styles Group on the Home tab of the Ribbon
- Click New Rule
- Select a rule type from the list
- Complete the fields in the Edit the Rule Description area
- Click Ok
- Click Conditional Formatting from the Styles group of the Home tab on the Ribbon.
- Click Manage Rules
- Click Ok after making your changes
- Click the Conditional Formatting button from the styles group of the Home tab on the Ribbon
- Point to Clear Rules
- Select Selected Cells or Entire Worksheet
The New Formatting Rule dialogue box appears
The fields displayed will depend on the rule type selected
The example below will format all cells that's date value has past in red
The conditional formatting is applied.
The Rules Manager allows you to create, edit and delete all condition formatting rules in one place.
The Conditional Formatting Rule Manager dialogue box appears
The Show Formatting Rules for list arrow enables you to change from viewing the current selection to viewing all the conditional formatting rules in the worksheet, or any other sheet in the workbook.
The New Rule, Edit Rule and Delete Rule buttons enable you to manage your conditional formatting rules as needed.
The Move Up and Move Down arrows allow you to modify the order that the formatting rules are tested.
Clear rules will remove any conditional formatting rules from and selected range or the entire worksheet quickly and easily.
The conditional formatting rules are removed.