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
  4. The New Formatting Rule dialogue box appears

    Create a new conditional formatting rule

  5. Select a rule type from the list
  6. Complete the fields in the Edit the Rule Description area
  7. 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

    Format expired dates

  8. Click Ok
  9. 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
    3. The Conditional Formatting Rule Manager dialogue box appears

      Conditional Formatting rules manager

      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.

    4. Click Ok after making your changes
    5. 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
      4. The conditional formatting rules are removed.

Follow us on

Facebook  Twitter  You Tube 

Excel 2010 Superhero Course