How to Remove Conditional Formatting in Google Sheets

how to remove conditional formatting in google sheets

If you receive a spreadsheet with conditional formatting in it and don’t know how to get rid of them, here’s how to remove conditional formatting in Google Sheets.

Conditional formatting is useful for stylizing the spreadsheet, making it easier to read. It works like alternate color in Google Sheets which color every odd/even row but support more function and condition to apply with like coloring an empty row.

It is also used to make a progress bar in Google Sheets as well, and other stylizing methods to make the spreadsheet more appealing visually.

If you wish to clear the conditional formatting, here’s how.

How to copy and paste without the conditional formatting rules

You can get rid of conditional formatting by copying and pasting the data. This method can also be used when you want to copy data with conditional formatting in it but don’t want to paste the style into other apps.

Click any cell inside the dataset, and press CTRL+A which will select the entire area of the dataset. Press CTRL+C to copy.

selecting all dataset

Click any empty area of your sheet that would fit the previous dataset you’ve copied, right-click and select Paste special > Paste values only.

paste values

Pasting values only will remove the conditional formatting when pasting.

How to remove conditional formatting in Google Sheets

Removing conditional formatting is simple. Open Google Sheets, and look for the spreadsheet with the conditional formatting you want to get rid of, and open the spreadsheet.

Click any cell inside the conditional formatting dataset.

how to remove conditional formatting in google sheets

Click Format, and select Conditional Formatting.

conditional formatting

Here, the conditional format rules are detected. To remove the conditional formatting, simply click the trash icon (Remove rule).

removing conditional formatting

The conditional formatting is now removed.


Google Sheets provides its features in simple ways but you can still manage to add or clear conditional formatting. You can clear it by clicking the trash can icon or by copying and pasting the data as values.

Leave a Comment

Your email address will not be published. Required fields are marked *