Forum Discussion
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).
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?
Thanks for your response. https://kdcservices123-my.sharepoint.com/:x:/g/personal/kamal_aly_kdc-services_com/EZdqxnM6aRFNs6DmQRQkjDsBmcAhVoC4RSTqvHU32boWFQ?e=uBCOpz
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).
