(Icon sets) in Conditional Formatting

ahmad ali



could you please explain the reason behind (Icon sets) in Conditional Formatting - I mean how Excel decides which icon to choose!    Thanks

please see the image



2 Replies

Well, I guess you have to ask the programmer.

But if you are not satisfied with Excel's interpretation then you can always change the rule.


Excel conditional formatting Icon Sets, Data Bars and Color Scales


Thank you very much


Related Conversations
conditional formatting with formula
kdwork in Excel on
3 Replies
Conditional Formatting - Consider Only Value as Lowest Value
Ben Smith in Excel on
2 Replies
Date Formatting Won't Change
Steve Gould in Excel on
10 Replies
Format Date in header and footer
Joe Cangelosi in Excel on
3 Replies