SOLVED

Conditional Formatting

Occasional Contributor

Can anyone please help me understand why the conditional formatting is not working properly.

Capture.PNG

2 Replies
best response confirmed by rhockman (Occasional Contributor)
Solution

@rhockman 

The 69.5 and 59.5 in the rule do not refer to the values in the cells, but they specify that the bottom 59.5% of the data will be red, the next 10% yellow, and the rest green.

Change the rule to refer to the numbers 0.695 and 0.595 (corresponding to 69.5% and 59.5%):

S0789.png

Thank you!