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:

​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:    Read More

​