Remove conditional formatting

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

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