Excel > Excel 2007 Intermediate > Formatting a Worksheet

Managing Conditional Formatting

You can create your own conditional formatting rules and editing any existing rules on the workbook.

Create a new rule

1. Select the range of cells you wish to format with the new rule
2. Click Conditional Formatting from the Styles Group on the Home tab of the Ribbon
3. Click New Rule

The New Formatting Rule dialogue box appears



4. Select a rule type from the list
5. Complete the fields in the Edit the Rule Description area

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



6. Click Ok

The conditional formatting is applied.

Manage Rules

The Rules Manager allows you to create, edit and delete all condition formatting rules in one place.

1. Click Conditional Formatting from the Styles group of the Home tab on the Ribbon.
2. Click Manage Rules

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.

3. Click Ok after making your changes

Clear Rules

Clear rules will remove any conditional formatting rules from and selected range or the entire worksheet quickly and easily.

1. Click the Conditional Formatting button from the styles group of the Home tab on the Ribbon
2. Point to Clear Rules
3. Select Selected Cells or Entire Worksheet

The conditional formatting rules are removed.

Conditional Formatting Vlookup

Guides