Conditional Formatting Using Icon Set

New Contributor

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




4 Replies


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?

@Hans Vogelaar 


Thanks for your response. Book1 

best response confirmed by Peter Bartholomew (Respected Contributor)


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





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