Conditional Formatting Not working

[RKS2nd]

I have created a conditional format to apply a graded 3 color scale against the percentage of completion on 1 column with 34 cells. Accepting the standard values and colors for lowest, 50% and highest values, I would expect a 50% to be colored with yellow and 90% closer to medium to light green. I have one cell at 53% that is displaying orange and 2 cells in the 90% range displaying yellow. I have attempted changing the color values with no appreciable change.

Any ideas on how to get the 3-color scale to present correctly?

 

[Fluff]

Change the midpoint from Percentile to percent.

 

[RKS2nd]

Conditional Formatting configured based on previous guidance. New year tracking and the formatting fails to work as programmed. Any suggestions?

 

[Fluff]

From what you have shown in your image it's working perfectly.

 

[RKS2nd]

Shouldn't the 1st entry (8%) be a shade of red?

 

[Fluff]

From your image it's the only value that isn't 0%, so it's the highest value & therefore green.

 

[RKS2nd]

From your image it's the only value that isn't 0%, so it's the highest value & therefore green.

That makes sense. Thanks

 

[Fluff]

You're welcome