See all How-To Articles

Remove Conditional Formatting in Excel & Google Sheets

In this tutorial, you will learn how to remove conditional formatting in Excel and Google Sheets.

 

remove conditional formatting excel

 

Remove Conditional Formatting

In Excel, you can remove conditional formatting rules for either selected cells or the entire sheet. Say you have a worksheet with numbers in Column B as shown below.

 

remove conditional formatting initial data

 

In the range B3:B11, there is a conditional formatting rule which fills the background color of a cell in green if the cell’s value is greater than the range’s average value.

To remove conditional formatting from a range of formatted cells, select the range and in the Ribbon, go to Home > Conditional Formatting > Clear Rules > Clear Rules from Selected Cells.

 

remove conditional formatting selected cells

 

As a result, all formatting rules are now cleared.

 

remove conditional formatting final data

 

Conditional formatting can also be removed from the entire sheet at once.

To do this, in the Ribbon, go to Home > Conditional Formatting > Clear Rules > Clear Rules from Entire Sheet.

 

remove conditional formatting entire sheet

 

After this, all conditional formatting from the active sheet will be cleared.

NOTE: There’s also the option to use VBA code to remove conditional formatting.

Remove Conditional Formatting in Google Sheets

In Google Sheets, there is no option to clear all conditional formatting at once. You must remove conditional formatting rules one at a time.

1. Click anywhere in the range where you want to remove conditional formatting, and in the Menu, go to Format > Conditional formatting.

 

google sheets remove conditional formatting

 

2. On the right side of the sheet, the Conditional format rules window will appear.
(1) Position the cursor on the rule you want to remove, and (2) click on the bin icon when it appears.

 

google sheets remove conditional formatting 2

 

3. If there are more rules, delete them in the same way: manually, one-by-one.

The result is the same as in Excel: All conditional formatting rules are cleared.

 

google sheets remove conditional formatting final