Google Sheets, Conditional Formatting by Percentage Categories

user_3188120 0
Viewed 34187

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?

gs-conditional-formatting google-sheets
3 Answers

When putting in conditional formatting with cell that has a percentage value in it you need to give ranges in the range of 0 to 1. In other word to set a format for range between 10% and 40% you would select "Is Between" and for values put in 0.1 and 0.4. This will apply formatting correctly. For percentages over 100% use 1.xx over 200% 2.xx etc...

user_17224920
Related