Conditional Formatting Using Icon Set

[KamalAly]

I am trying to use "Conditional Formatting-Icon Set" and the results don't come out correctly (as per the conditions I set). Has anyone had this problem with "Conditional Formatting-Icon Set"?

I am trying to apply the following rule on a dataset that is organized in 4 columns

When value is > 45% then put a green icon

When value is >=40 and <45 then put yellow icon

When value is < 40 then put red icon

Thanks

[#2]

@KamalAly 

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

[#3]

@Hans Vogelaar 

Thanks for your response. Book1 

[#4 · Accepted solution]

@KamalAly 

You should set the Type of the conditions to Number, not Percent, and set the Value to 0.45 and 0.4 (corresponding to 45% and 40%, respectively).

[#5]

@Hans Vogelaar Thanks a lot! it works now. Really appreciate it.