Turn Off Conditional Formatting in Google Sheets

To turn off conditional formatting in Google Sheets, open the sheet in a browser, select Format > Conditional formatting, then click the trash icon beside the rule you want to remove. Google Sheets does not provide a simple on/off switch for a rule, so for a temporary pause you need to preserve the rule’s details and change how it applies instead of deleting it.

What turning off conditional formatting means

Conditional formatting automatically changes a cell’s appearance when a condition is met. A rule might color overdue dates red, shade duplicate entries, or highlight values above a target. The formatting is controlled separately from the cell’s contents and ordinary formatting, such as a fill color you set manually.

In Sheets, rules are attached to a range and describe both the condition and the appearance to apply. You can remove a rule, edit its condition, or change its range. There is no general pause button that leaves every part of a rule untouched while switching its effect off. That distinction matters: deleting a rule is a clean way to stop its effect, but it also removes the rule’s setup from the sheet.

If colored cells return after you edit data, that usually means a conditional-formatting rule is still active. If the color stays the same even when the rule is gone, it may instead be ordinary cell formatting, a theme, or another visual feature. The right fix depends on which of those is responsible.

Remove one conditional-formatting rule

Open the spreadsheet in Google Sheets in a web browser. You need permission to edit the sheet to change its rules.
Select a cell within the range that is being formatted. If you are unsure which cells are affected, select a cell that visibly has the color or style you want to remove.
Choose Format > Conditional formatting. The conditional-formatting rules panel opens on the right.
Review the rules listed in the panel. Click a rule to see its condition, formatting style, and the range shown under Apply to range.
When you have identified the rule to remove, click its trash icon. The rule is deleted, and the conditional effect from that rule stops applying.

Check the affected cells after removing it. If the appearance remains, inspect the other rules in the panel: more than one rule may cover the same cells. Remove only the rule you intend to remove. A rule can apply across a large range, so its listed range may include cells that are not currently selected.

To remove several rules, delete them individually from the panel, checking their ranges before each deletion. This is safer than assuming every listed rule belongs to the selected cell. A rule may also cover multiple nonadjacent cells or a whole column.

Temporarily pause a rule without losing its setup

If you may need the rule later, do not delete it until you have a way to recreate it. First record its range, condition, formula if it uses one, and formatting choices. You can copy those details into a note or make a duplicate of the sheet as a reference. Duplicating the sheet is often the easiest safeguard when several rules are involved.

One temporary workaround is to edit the rule so it can never match. In the panel, change the rule type to Custom formula is and enter =FALSE. Since FALSE is never a true condition, the rule will not apply its formatting. This keeps the rule and its style in place, but it replaces the original condition; note that condition first so you can restore it later. When you want the formatting again, edit the rule and put back its original condition or formula.

Another option is to change Apply to range so the rule no longer covers the cells you are working on. This can be useful for a short test, but it is easy to forget the altered range. Avoid choosing an arbitrary unused range if new data might later be entered there, because the rule could start affecting those cells.

There is no universal pause method that preserves every detail automatically. For an important sheet, duplicate it before changing rules, or make a careful note of the original settings. If the change is only temporary and you have not made other edits, Undo may reverse it, but Undo is not a reliable long-term backup.

Turn off formatting for only some cells

You do not have to remove a rule from the entire sheet to stop its effect in one area. Open the rule and check Apply to range. You can edit the range so it covers only the cells that should continue to respond. For example, if a rule applies to A2:A100 but you no longer want it on rows 50 through 100, change the range to A2:A49 if that matches your layout.

Be precise when changing ranges. A range such as A2:A49 excludes row 1 and rows 50 onward, while A:A refers to the whole column. If a rule uses a custom formula that refers to another cell, changing the start of the range can also change which row the formula is evaluated against. After editing, test a cell near the top and bottom of the range to make sure the result matches what you intended.

If the same condition is needed in two separate blocks, the range field can accept multiple ranges separated by commas, such as A2:A20,C2:C20. Confirm that the interface accepts the range and that both blocks behave as expected. For a complicated setup, retaining separate rules can be easier to understand than combining many areas into one.

Why colors may remain or return

A common source of confusion is using Format > Clear formatting to remove conditional colors. That command clears ordinary formatting, but it does not serve as a dependable way to delete conditional-formatting rules. If the rule remains and its condition is still true, the conditional appearance can continue or return as Sheets evaluates the cells. Remove or edit the rule in the conditional-formatting panel instead.

Other causes are worth checking before you change anything:

Another rule covers the cells. Review all rules shown for the selected cells and inspect their ranges, not just the first rule you notice.
The color is manually applied. If there is no matching rule, select a cell and inspect its fill and text-color controls. Ordinary formatting may need to be cleared separately.
The rule’s condition is still true. A rule based on a date, text value, or number can apply again as soon as the data meets its condition.
The affected range is broader than expected. Check whether the rule applies to an entire column or includes additional rows or columns.
You are viewing a different tab or copy. Rules belong to sheet tabs, and a duplicated sheet may have its own copied rules. Confirm you are editing the tab where the color appears.

When a rule is hard to identify, select a cell with the unwanted appearance and inspect the rules panel one by one. Compare both the rule’s condition and its applied range. Avoid deleting every rule as a first step: that can remove useful alerts elsewhere in the sheet.

Choose the safest method for your situation

The best approach depends on whether you want a permanent cleanup, a temporary pause, or a change limited to part of the sheet.

Remove the rule when it is no longer useful and you do not need its setup. This is the simplest permanent fix.
Change the rule’s range when the formatting should continue in some cells but not others.
Use a never-true condition temporarily when you want to keep the rule entry, provided you have recorded its original condition.
Duplicate the sheet first when the rules are valuable, numerous, or difficult to reconstruct. Keep the copy as a reference and make changes to the working tab.

For a shared spreadsheet, consider telling collaborators before removing or changing a rule. A conditional color may be part of someone else’s review process, even if it looks decorative. Also consider whether the rule communicates important information, such as overdue work or out-of-range values. Removing the visual alert does not change the underlying data or correct the condition that triggered it.

Google Sheets compared with Excel

In Google Sheets, use Format > Conditional formatting in a browser to inspect, edit, and delete rules. Excel organizes its conditional-formatting tools differently; in Microsoft Excel for Microsoft 365 on Windows, the main ribbon path is Home > Conditional Formatting, with rule management available through Manage Rules. The menus and rule-management controls are not interchangeable, so do not follow Excel instructions when working in Sheets.

In either program, removing a rule is different from clearing a cell’s ordinary fill color. If you are following instructions written for another spreadsheet app, check that the product and menu names match the one you have open. Google Sheets in a browser is the focus here; its phone and tablet apps may present controls differently.

Frequently Asked Questions

Can I turn off all conditional formatting in Google Sheets at once?
Sheets does not offer a single general off switch for all rules. Open Format > Conditional formatting and remove or edit the rules you no longer want. Check each rule’s range so you do not remove conditions that apply to other parts of the sheet unintentionally.

Will deleting a rule erase my cell values?
No. Deleting a conditional-formatting rule changes the automatic appearance, not the values or formulas in the cells. It also does not necessarily remove ordinary formatting that was applied separately.

Can I temporarily disable a rule and restore it later?
There is no built-in pause toggle. Record the original settings, then use a temporary workaround such as changing the condition to the custom formula =FALSE. Restore the saved condition when you want the rule active again.

Why does a color come back after I clear formatting?
A conditional-formatting rule may still be active and applying its style whenever its condition is met. Open the rules panel and remove or edit the relevant rule. If no rule explains the color, inspect the cell’s ordinary formatting and check for other rules covering that range.

Can I remove conditional formatting from just one cell?
Yes, if you change the rule’s applied range so that the cell is no longer included, or remove a rule that applies only to that cell. Check the full range before editing, since changing a rule can affect every cell it covers.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.