How To Remove Conditional Formatting In Google Sheets

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

How To Remove Conditional Formatting In Google Sheets

When collaborating on Google Sheets that others have created or edited, sometimes you’ll come across cells that are colored in undesirable or illogical ways.

In some cases, you can simply use the text color and fill color options in the toolbar to update the cell formatting, but sometimes you’ll find that the colors remain the same no matter how you format the cell.

This is because a conditional formatting rule has been applied to this cell and needs to be removed before other formatting can be seen for that cell

Conditional formatting rules are a way of formatting cells based on what they or other cells contain.

It’s useful for highlighting cells that reach a certain value, such as items for which stock is low or excessive spending in a budget category, but it can easily become outdated and cause confusion

Identifying Cells with Conditional Formatting

You can recognize cells that have conditional formatting applied by looking at the text color and fill color options in the toolbar.

If the selected cell or range has conditional formatting affecting it, the colored line underneath these icons will be two thin lines instead of one thick line

Without conditional formatting:

With conditional formatting:

Removing Conditional Formatting

To remove conditional formatting from a single cell or range, follow these steps

Step 1

Select the cell or range you want to remove conditional formatting from

Step 2

Open the Format menu, then click on the Conditional Formatting option

Step 3

The Conditional Format Rules sidebar will open, displaying all conditional formatting rules applied to the selected range

Step 4

Hover over the conditional formatting rule you want to delete and a trashcan icon will appear. Click on this to delete the rule

Step 5

Repeat Step 4 as needed to remove all unnecessary conditional formatting rules applied to the cell or range.

Note that conditional formatting rules can be applied to any number or size of ranges, so it’s a good idea to check what ranges a conditional formatting rule applies to before deleting it, as they may still be useful elsewhere in the spreadsheet

Summary

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to remove conditional formatting in Google Sheets. Want more? Check out all the Google Sheets Tutorials.

Get more Google Sheets stuff

Subscribe to our mailing list and get interesting Google Sheets stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.