Google Sheets, Conditional Formatting by Percentage Categories
<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>