Clear formatting rules

To clear a rule, follow these steps:

1. Open the Conditional formatting pane.
2. Hover your cursor over a rule in the list.
3. Click  More and select Clear.

If you want to clear the rule only from the selected cells, follow these steps:

1. Select the range of cells.
2. Clear it in one of the following ways:
   • On the Home tab, in the Data group, or on the Data tab, click the arrow to the right of the  Create formatting rule button and select Clear rules > From selected cells from the drop-down menu.
   • Right-click the selected range and run the Clear rules > From selected cells command from the context menu.

The deletion applies to all rules in the selected cells. If the deletion affects only part of the range covered by the rule, the rule will continue to apply to the remaining cells, and its scope will be adjusted accordingly.

tip

The Clear all and Clear formatting commands also remove conditional formatting rules from selected cells.

You can clear all rules on the current sheet or in the entire document in one of the following ways:

• On the Home tab, in the Data group or on the Data tab, click the arrow to the right of the  Create formatting rule button and select Clear rules > From this sheet / From entire document from the drop-down menu.
• Right-click the selected range and run the Clear rules > From this sheet / From entire document command from the context menu.