Icon Set in Conditional Formatting Issues

New Contributor

Hello -- the rules set in icon condition formation do not work properly.

It does not display the proper icons. It tried with both options, based on the number and the second with percentage. 

Could you please fix this or at least suggest how to overcome it?

I would like to insert an excel file to show the example but can't find an option like that...


4 Replies


If you cannot attach a sample workbook, you can make it available through OneDrive, Google Drive, Dropbox or similar, and post a link in a reply.


Thanks. Does the attached version do what you want? If not, please explain in detail how you want the icons to work.

Yes, it does! Big thank you for support