title: How to speed up heavy conditional formatting rules
body: <p>At our marketing company/agency, we're using a master tracker in Google Sheets to keep track of all paid advertising campaigns that we are handling for our clients. The document is getting longer and longer, and the variety of conditional formatting rules we are using is getting heavy and slow upon any change made to the document.</p>
  
  <p>Five employees are using the document at any given time, making changes to the "STATUS" column upon any change to the campaign – if it is ready to upload, if it is LIVE, if it is paused etc. The conditional formatting simply changes the color of each line based on the value in the "STATUS" column. It also looks at the start/end dates and marks the line red if there is an issue. Etc.</p>
  
  <p>How can I speed up processing using this document? <a href="https://docs.google.com/spreadsheets/d/1Znlz3NsGyzeDtnFOJ0cGH7uI7c_v4YHDynYZzc_h4aw/edit?usp=sharing" rel="noreferrer">I have created a minified version of our tracker with one line for each conditional formatting rule to make it easy for you to have a look.</a></p>
  
  <p>I'm sure there are smarter ways to consolidate the rules and/or build a script that can handle the task more easily and more efficiently.</p>