Last Updated on November 2, 2023 by Jake Sheridan
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
Select the cell or range you want to remove conditional formatting from
Open the Format menu, then click on the Conditional Formatting option
The Conditional Format Rules sidebar will open, displaying all conditional formatting rules applied to the selected range
Hover over the conditional formatting rule you want to delete and a trashcan icon will appear. Click on this to delete the rule
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
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.
More ways to do conditional formatting Google Sheets:
- How To Do Conditional Formatting
- Copy Conditional Formatting
- Conditional Formatting Based On Another Cell
- Conditional Formatting for Duplicates
- Conditional Formatting with a Checkbox
- Conditional Formatting with Multiple Conditions
- Conditional Formatting Based On Another Sheet
- Apply Conditional Formatting Across An Entire Row
- Conditional Formatting to Compare Two Columns
- Conditional Data Validation
- Color Scale Based On Another Cell
- Relative Reference
- Conditional Formulas
- Conditional Formatting Based On Another Cell Not Empty
- Conditional Formatting Based On Another Cell Date
- If Cell Contains Text in
- Highlight Cells
- Highlight Duplicate Cells
- Make Negative Numbers Red