(Icon sets) in Conditional Formatting

[ahmad ali]

Hello,

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]

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

[#3]

Great

Thank you very much