Forum Discussion
Conditional Formatting Help with Percentages
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:
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
