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?



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




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