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

Applies To: Excel 2016, Excel 2013



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language