title: Google Sheets, Conditional Formatting by Percentage Categories
body: <p>I'm looking to create some conditional formatting based upon a set of three percentage categories (please see <a href="https://docs.google.com/spreadsheets/d/12CmHVyW8EbxqCX5PCZRio0MB3juXQoLP5oYzZ8VZU_o/edit?usp=sharing" rel="noreferrer">the following sheet</a>), where a color is applied to multiple cells, but not all in a row:</p>
  
  <ol>
  <li>90% - 100%: Green</li>
  <li>50% - 89%: Yellow</li>
  <li>0% - 49%: Red</li>
  </ol>
  
  <p>I'm able to get the percentages to change color based upon their content, but so far I've not been able to apply this change to the other cells. Is there a conditional formatting custom formula that I can use to do this? </p>