Remove conditional formatting

Follow these steps if you have conditional formatting in a worksheet, and you need to remove it.

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 that appears to the bottom right of the selected data.

   Notes: Quick Analysis Lens will not be visible if:

   • All of the cells in the selected range are empty, or

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

   

Find and remove the same conditional formats throughout a worksheet

1. Click on 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. to select all of the cells that contain the same conditional formatting rules.

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

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Copy conditional formatting

Use a formula to apply conditional formatting