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 ...
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?
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).
HansVogelaar Thanks a lot! it works now. Really appreciate it.