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