Remove conditional formatting

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

In an entire work sheet

  • 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.

  3. Click Clear.

Clear option

Find and remove the same conditional formats

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

  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 the cells that contain the same conditional formatting rules are selected.

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

More about conditional formatting

Applies To: 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!

Support resources

Change language