Quick wins for a faster PC:
Scan for outdated or missing drivers - takes under a minuteDriver Scan →Repair Windows errors before they cause bigger problemsFix Now →iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
To remove a conditional-formatting rule in Google Sheets, open Format > Conditional formatting, find the rule in the sidebar and click Remove. This deletes the rule rather than clearing other formatting such as fonts, borders or number formats.
Remove a rule on a computer
-
Open the spreadsheet and select a cell affected by the unwanted formatting. If you know the exact range, you can select it instead.
-
Choose Format > Conditional formatting. The rules appear in a panel on the right. Google’s computer instructions describe this workflow.
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy. -
Review each rule and its applied range. Select the rule responsible for the appearance you want to remove.
#1 Best Overall
Sale![The Google Workspace Bible: [14 in 1] The Ultimate All-in-One Guide from Beginner to Advanced | Including Gmail, Drive, Docs, Sheets, and Every Other App from the Suite](https://m.media-amazon.com/images/I/41AWmhmGFuL._SL160_.jpg)
The Google Workspace Bible: [14 in 1] The Ultimate All-in-One Guide from Beginner to Advanced | Including Gmail, Drive, Docs, Sheets, and Every Other App from the Suite- The Google Workspace Bible: [14 in 1] The Ultimate All in One Guide from Beginner to Advanced Including Gmail, Drive, Docs, Sheets, and Every Other App from the Suite
- ABIS BOOK
-
Click Remove for that rule, then check the affected cells.
Review conditional-formatting rules across a whole sheet
To review rules across the sheet rather than only those associated with a particular cell, select the entire sheet before opening Format > Conditional formatting. Inspect the listed rules and remove only those you no longer need. Google recommends reviewing unnecessary, duplicated or overlapping rules as a possible performance cleanup, but does not quantify a speed improvement. Google’s performance guidance explains the recommendation.
Remove a rule in the Google Sheets Android app
-
Select the range affected by the rule.
-
Tap Format > Conditional formatting.
-
Tap Remove for the rule you want to delete, then tap Done.
Outdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware matchPC Slower Than It Used to Be?
A free scan shows the junk files, broken settings and background clutter dragging Windows down - then fixes them in one click.Free scan · Windows 10 & 11Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
These steps are documented in Google’s Android instructions. They should not be assumed to describe the iPhone or iPad interface.
Remove the rule without clearing other formatting
Use Remove in the conditional-formatting panel when you want to stop a rule from controlling cell appearance. Avoid Format > Clear formatting if you need to preserve other styling: a Google Docs Editors Community answer notes that Clear formatting also removes other kinds of cell formatting. Community guidance on Clear formatting discusses this distinction.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.If the formatting comes back or the rule is hard to find
Check the rule’s applied range
Select a cell that visibly has the formatting, then open the conditional-formatting panel and inspect the rule’s range. A rule may not appear relevant if you selected a cell outside the range it affects. This is practical navigation guidance also raised in a Google Sheets community discussion.
Check whether a paste carried the rule
Copying and pasting cells or ranges with conditional-formatting rules can apply those rules to the pasted content. If the appearance returns after a paste, inspect the pasted cells’ rules and applied ranges. Google documents this copy-and-paste behavior.
The Tool Desk
Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Keep filter troubleshooting separate
If you are troubleshooting why Create a filter is unavailable, Google lists conditional-formatting rules among the items to check. That is a separate issue; remove a rule only if it is actually necessary for your task. See Google’s filter troubleshooting guidance.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
