Conditional Formatting Help with Percentages

Copper Contributor

Hi there,

 

I'm trying to do icon set conditional formatting on percentages in Excel. My ideal formatting would be a red icon for anything over 15%, yellow icon for anything between 10-14.9%, and green icon for anything less than 10%. Below is what I've selected in my parameters, but it's not giving me my desired formatting. Can anyone assist me?

 

llawley_0-1718032609577.png

This is what is happening when I use the above parameters:

llawley_0-1718032841818.png

 

 

2 Replies

@llawley Obviously, 15% = 0.15. So set limits as decimal numbers.

Thanks. I had tried that, but used "percentage" as my type instead of "number". Appreciate the help