Google Spreadsheet Conditional Formatting Toggle

Question

So I'm trying to create a spreadsheet to keep track of multiple people and their progress as they complete tasks. On the top of the spreadsheet are toggles. I've used the conditional formatting

=RegExMatch($C13,"Not Started")

(as an example) to change to a specific color with each project status. I would like the toggles on the top to toggle the conditional formatting on the entire spreadsheet. Is this possible? What formulas would I need?

@RobinGertenbach If a toggle is off, then that color will not display on the spreadsheet, simply white background. As if conditional formatting were set to white. — user5621706
How about =AND(RegExMatch($C13,"Not Started"),$A$1="Toggle On")? — Robin Gertenbach
It sounds like you're trying to recreate project management software. Theses types of tools exist in many different forms as web apps. If you're looking for collaborative task tracking, I like web apps like Asana or Azendoo (my personal favorite for teams). If you're looking for kanban-style "not started", "in progress" etc. try an app like Kanbanchi (integrated with google drive) or Trello. My personal philosophy is why recreate the wheel by hand when someone else is mass producing them in a factory. The tools i mentioned above also have some good free options. — Brady
@RobinGertenbach Your solution worked, thank you. If you want, you can post your answer on the main thread? — user5621706

Robin Gertenbach Robin Gertenbach · Accepted Answer · 2015-12-01T09:25:27

To toggle the formatting based on a condition it's enough to include the condition in the formatting rule. This can be accomplished easiest using AND() like this:

=AND(RegExMatch($C13,"Not Started"),$A$1="Toggle On")

Google Spreadsheet Conditional Formatting Toggle

1 Answers