Chat with us, powered by LiveChat

How to Edit Conditional Formatting in Excel

How to Manage Conditional Formatting in Excel

How to Edit Conditional Formatting in Excel

You can edit an existing rule if the criteria have changed or if you simply want to update the format. The Rules Manager allows you to manage all aspects of conditional formatting—creating, editing, and deleting rules.

Edit a Conditional Formatting Rule

  1. Click a cell in the range of an existing conditional formatting rule.
  2. Click the Conditional Formatting button on the Home tab.
  3. Select Manage Rules.
    Edit a Conditional Formatting Rule

    The Conditional Formatting Rules Manager, where you can edit or delete existing rules, opens.

    The rules shown here only include those applied to your current selection. If you want to see all the conditional formatting rules used in the worksheet, click the Show formatting rules for list arrow and select This Worksheet.

  4. Select the rule you want to edit.
  5. Click Edit Rule.
    Edit a Conditional Formatting Rule
  6. The Edit Formatting Rule dialog box displays.

  7. Make your changes to the rule.

    The preview at the bottom of the Edit Formatting Rule dialog box updates to reflect any changes you’ve made to the rule.

  8. Click OK.
    Edit a Conditional Formatting Rul
  9. Click OK again to commit the changes to the conditional formatting rule.
    Add Cells to the Watch Window

The rule is updated and any cells in the workbook using that rule update accordingly.

Change the Order of Conditional Formatting Rules

When there are multiple rules applied to the same range, two or more rules could apply to a single cell. You may need to change what order the rules are applied to give priority to the most important format.

  1. Click a cell in the range with multiple conditional formatting rules.
  2. Click the Conditional Formatting button on the Home tab.
  3. Select Manage Rules.
    Change the Order of Conditional Formatting Rules

    When there are multiple rules listed for a selection, they will be applied in the order they appear here, with the one at the top of the list taking precedence.

  4. Select the rule you want to resequence.
  5. Click the Move Up or Move Down arrow until the rule is positioned correctly.
  6. Click OK.
    Change the Order of Conditional Formatting Rules

The conditional formatting rules are applied according to the new sequence.

FREE Quick Reference

Click to Download