SOLVED

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

 

Thanks

 

4 Replies

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

@Hans Vogelaar 

 

Thanks for your response. Book1 

best response confirmed by Peter Bartholomew (Respected Contributor)
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).

 

S1992.png

 

S1993.png

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