Google Sheets: Delete Conditional Formatting Rules

Yes. In Google Sheets in a web browser, select a cell or range, open Format > Conditional formatting, then click the trash-can icon on the rule you want to remove. Deleting a rule stops its conditional appearance from being applied; it does not delete cell contents or ordinary formatting such as a manually chosen fill color.

What deleting a conditional formatting rule means

Conditional formatting is a set of instructions that changes how cells look when specified conditions are met. For example, a rule might color overdue dates red, shade values below zero, or apply a color scale to a range of scores. The rule is separate from the values and most ordinary formatting in the cells. Sheets checks the rule against the cells it applies to and displays the conditional style when the condition is true.

Removing the rule removes that instruction. If a cell was red only because a rule highlighted it, its conditional red appearance goes away after the rule is deleted. The value in the cell remains. If the cell also has a fill color applied manually, that ordinary fill can remain visible. This distinction matters when the goal is to make cells look plain: deleting conditional formatting and clearing formatting are different actions.

Deleting a rule also does not remove the underlying data, formulas, borders, number formats, or text. It is a change to the formatting logic, not a delete-cells operation. If other rules still apply to the same cells, those rules may continue to change their appearance.

How to remove one rule in Google Sheets

Use the conditional-formatting sidebar to remove a particular rule while leaving other rules in place. Before deleting anything, note the rule’s condition and range if you might need to recreate it. This is especially useful in a shared sheet or a large table where several rules have similar names or colors.

Select a cell within the area affected by the rule. If you know the full range, you can select that range instead.
Choose Format > Conditional formatting. Sheets opens the conditional-formatting rules sidebar.
Find the rule you intend to remove. Check its condition and the range shown under Apply to range so you do not remove a different rule by mistake.
Click the trash-can icon for that rule. The rule is removed, and the affected cells update to reflect any remaining rules and ordinary formatting.

If the sidebar shows several cards, click the one you want to inspect before acting. A rule’s condition might be a preset such as “Text contains,” a color scale, or a custom formula. Its range can be much larger than the cell you initially selected, so confirm both details rather than relying only on the color you see in the grid.

How to remove several rules or clear rules from a sheet

Google Sheets does not require you to clear all formatting just to remove conditional formatting. You can delete rules individually in the sidebar. For a broad cleanup, select the whole sheet using the blank square at the upper-left intersection of the row and column headers, then open Format > Conditional formatting. Review the rules shown for the selection and remove the ones you no longer want, one at a time.

Be careful with the phrase “all rules.” A rule may apply to only one table, a section of a sheet, or multiple areas. Selecting the whole sheet helps you inspect rules that affect the selection, but it is still worth checking the displayed ranges and conditions. Removing every listed rule may also remove useful alerts or visual cues that someone else relies on.

To remove one rule: select an affected cell, inspect the sidebar, and click the trash can on the intended rule.
To remove rules from a particular area: select cells in that area and inspect the rules and their apply-to ranges.
To clean up a whole sheet: select the sheet, review the rules displayed, and delete only those you have decided are unnecessary.

If a rule covers both the area you want to clean and cells you want to keep, deleting it removes the rule as a whole, not just its effect on the selected cell. Consider editing its apply-to range instead, or documenting its condition before changing it. Editing preserves the rule while narrowing where it operates.

What happens to colors and other formatting afterward

Conditional formatting is applied dynamically. Suppose cells B2:B20 turn green when they contain the word “Paid.” If you remove that rule, the cells stop receiving green from that condition. The text “Paid” remains, and any manually applied formatting remains too. If a second rule says to color overdue items red, that second rule can still affect cells in the same range.

This is why a cell may not become white or look completely unformatted after you delete a rule. It may have a manual background color, another conditional-formatting rule, or both. If the objective is to remove manual formatting as well, select the relevant cells and use Format > Clear formatting. That command clears ordinary formatting, so it can also affect choices such as font styling and number formats; use it only when that broader change is intended. It is not a substitute for deleting a conditional rule.

Likewise, deleting cell contents is not the way to remove a formatting rule. Clearing values or deleting rows may leave rules in place, depending on the rule and range. To change the rule itself, use the conditional-formatting sidebar.

Rules, ranges, and overlapping conditions

Each conditional-formatting rule has a condition and an apply-to range. The condition describes what Sheets checks; the range identifies the cells that can receive the formatting. A rule can cover a block of cells, a column, or a range that extends beyond the currently visible data. Selecting just one cell does not mean the rule applies only to that cell.

Overlapping rules are a common source of confusion. For instance, a range may have one rule that highlights negative numbers and another that highlights values that need review. Removing the negative-number rule may leave the review rule active. The visible result can therefore change without becoming unformatted. Inspect the full list of relevant rules in the sidebar before concluding that deletion failed.

Custom-formula rules can also use cell references whose behavior depends on the range and how the formula was written. If you are preserving a rule but changing its scope, carefully check its condition and apply-to range after editing. A reference intended to evaluate each row can behave differently if the range is shifted or expanded. If you are not sure how a custom rule works, make a copy of the sheet or record the rule details before changing it.

Common problems and safe ways to troubleshoot

The rule is not visible: select a cell that should be affected, then reopen Format > Conditional formatting. Rules are easier to identify when you inspect a cell inside their apply-to range.
The color remains: check for another rule on the same cells and for manually applied formatting. The rule you removed may not have been the only source of the appearance.
You removed too much: if the deletion was the most recent action, try Undo immediately with Ctrl+Z on Windows or Command+Z on Mac. Confirm that the rule has returned. Undo can also reverse other recent edits, so check the sheet before continuing.
You cannot edit the rule: confirm that you have permission to edit the spreadsheet. A viewer or commenter may be able to inspect a file but cannot change its formatting rules.
The wrong cells changed: inspect the apply-to range. A rule can affect a larger area than the selected cell, and deleting it affects the rule’s scope rather than only the current selection.

For important shared sheets, record the rule condition and range before removal, or make a copy of the tab or spreadsheet first. A copy is particularly useful if the rule contains a custom formula or if other people depend on the color cues. In a shared file, consider telling collaborators what changed; otherwise, they may mistake the altered appearance for a change in the data.

Google Sheets compared with Excel

The concept is similar in Google Sheets and Microsoft Excel: conditional formatting is managed separately from cell contents, and removing a rule is different from clearing ordinary formatting. The menu paths and rule-management interfaces are not identical, however. In Google Sheets, use Format > Conditional formatting and remove rules from the sidebar. Excel for Microsoft 365 on Windows uses Home > Conditional Formatting > Manage Rules to review and delete rules.

Instructions for Excel should not be followed literally in Sheets. For example, Excel’s Manage Rules dialog is not the Google Sheets control panel. If you are working in Sheets in a browser, use its sidebar and check the apply-to range there. This is also why a spreadsheet tutorial written for Excel may describe buttons or dialogs that are not present in Google Sheets.

Frequently Asked Questions

Can I delete conditional formatting without deleting the cell values?

Yes. Removing a rule in Format > Conditional formatting changes the formatting instructions, not the data. Cell values and formulas remain in place.

Why is the cell still colored after I delete a rule?

Another conditional-formatting rule may still apply, or the color may have been set manually. Check the remaining rules in the sidebar. If you also want to remove ordinary formatting, use Format > Clear formatting only after considering what other formatting that command will clear.

Can I remove conditional formatting from just one cell?

You can remove a rule that affects a selected cell, but the rule may apply to a wider range. Deleting it removes that rule for its apply-to range, not just for the selected cell. To preserve the rule elsewhere, edit its range rather than deleting the entire rule.

Does clearing formatting delete conditional-formatting rules?

Do not treat Format > Clear formatting as the way to manage conditional rules. It is intended to clear ordinary cell formatting. To reliably inspect and remove conditional-formatting rules, open the conditional-formatting sidebar and delete the relevant rule there.

Can I undo deleting a rule?

Try Ctrl+Z on Windows or Command+Z on Mac immediately after removal. If it restores the rule, verify its condition and range. Undo reverses the most recent action, so it may also undo another edit if you have continued working.

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.