Conditional Formatting Background Color

You need to change the value 0.1 in your Green Rule to 0 instead.

When 2.77% and 8.28% are translated to decimal numbers, they will become 0.0277 and 0.0828 respectively. Both fall in the interval between 0 and 0.1, which your rules are currently not coloring.

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.

Hi apenaranda ,

Jonvoge Good Answer!
And you can also change here into "Percent":

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.