I'm looking to create some conditional formatting based upon a set of three percentage categories (please see the following sheet), where a color is applied to multiple cells, but not all in a row:
- 90% - 100%: Green
- 50% - 89%: Yellow
- 0% - 49%: Red
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?