What is icon set in excel

What is icon set in excel and how do we apply?

In Excel Conditional Formatting Icon Sets mostly used to represent data in a different shape which will make the sheet more significant by using a different kind of shapes.  Icon sets contain various icon formatting shapes like Arrow, Traffic Light, Flag, etc.

To add an icon set, please follow the below steps

Click on conditional formatting > Icon Sets > Select Any Icon.

conditional formatting icon sets the percentage

 By default, for 3 icons, Excel calculates the 67th percent and 33th percent. But you can customize according to your work requirement.  

On status column put again all value or put formula like below screen shoot.

excel 2007 custom icon sets

For customization select the column range and click on Conditional Formatting and select Icon Sets and choose the icon shapes you want to place. After choosing the icon click on More rules.

excel custom icon sets

After click on more rules, we can see various format rules. By default, it works on percent but our work base on value so we have chosen type as a number because the format rule is based on values and not on the percentage which is shown in the below image.

icon set conditional formatting formula

Green Color Flag: if the value is greater than or equal to 200000.

Yellow Color Flag: if the value is less than 200000 and greater than equal to 150000 percent.

Red Color Flag: if the value is less than 150000 percent.

I want to show only icon in status cells, so i marked show only icon but if you unmark it can show value+icon .

Create Your Own Excel Icon Set