How to delete conditional formatting rules

In this lesson, we’ll look at how to clear or delete conditional formatting rules.

Let’s take a look.

Before you clear conditional formats, you might want to verify where they are currently applied.

Choose Find & Select, then Conditional Formatting.

Excel will then select all cells that have conditional formatting applied in the current worksheet.

To remove an individual rule, just pick the rule and pick the Delete Rule button.

Repeat this process for each rule you’d like to remove.

Now, if you select Conditional Formatting under Find & Select, Excel will report no cells found.

Let’s undo our changes, and look at other ways to clear conditional formats.

Let’s undo changes one more time.

you might also clear all conditional formatting rules in a worksheet in one step.

Just select “Clear Rules” then “Clear Rules from Entire Sheet” from the Conditional Formatting menu.

Now if we check Manage Rules again, the list is empty.

There is no longer any Conditional Formatting in the worksheet.