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 g...
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