I have multiple conditional formatting rules in one of my Google Sheets, I would like to disable a few of those rules for some time and would like to enable them again. But I don't see any such feature.

Is it possible to do this either in Google Sheets?

  • Is it possible No. Disabling the conditional formatting rule removes this rule. Make a copy of worksheet and remove formattings which you do not need. – Akina Apr 17 '19 at 9:44
  • I don't prefer doing that as this is a sheet that is shared with multiple people. Creating a copy would change the link of the file. This may not be a problem for SharePoint Excel files, but it is an issue with Google Spreadsheets. – Gangula Apr 17 '19 at 9:46
  • Add another condition to check the contents of a cell that is not used. When that cell Contains something in makes your condition false and the formatting does not get applied. If the cell is empty/blank the condition becomes true and provided the remainder of your conditional formatting is true the formatting gets applied – Forward Ed Apr 17 '19 at 11:24
  • there isn't such functionality to switch off conditional formatting but you can do so by inserting ' in front of the formula:



| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.