google-sheetsgs-conditional-formatting

Google Sheets, Conditional Formatting by Percentage Categories

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:

  1. 90% - 100%: Green
  2. 50% - 89%: Yellow
  3. 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?

Solution

  • For range F3:H26 make 2 rules with 'your formula':

    1. =$F3>=0.9 -- green
    2. =$F3>=0.5 -- yellow

    and paint the range in red.

    That's it!

    Look at example