Forum Discussion
Solved
Conditional Formatting Using Icon Set
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
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).
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?
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).
