Remove conditional formatting

You’ve got conditional formatting in a worksheet, but now you want to remove it. Here’s how.

For an entire worksheet

  • On the Home tab, click Conditional Formatting > Clear Rules > Clear Rules from Entire Sheet.

In a range of cells

  1. Select the cells that contain the conditional formatting.

  2. Click the Quick Analysis Lens button image button that appears to the bottom right of the selected data.

    Important: Note that the Quick Analysis Lens will not appear:

    • If all of the cells in the selected range are empty, or

    • If there is an entry only in the upper-left cell of the selected range, with all of the other cells in the range being empty.

  3. Click Clear Format.

Clear option

Find and remove the same conditional formats throughout a worksheet

  1. Click a cell that has the conditional format that you want to remove throughout the worksheet.

  2. On the Home tab, click the arrow next to Find & Select, and then click Go To Special.

  3. Click Conditional formats.

  4. Click Same under Data validation.

    All of the cells that contain the same conditional formatting rules are selected.

  5. On the Home tab, click Conditional Formatting > Clear Rules > Clear Rules from Selected Cells.

More about conditional formatting

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×