Microsoft Excel 2007: Icon Sets
Archived Historical Data: Not Actively Maintained.
Microsoft Excel 2007 comes with a slew of Conditional Formatting options. The Icon Sets option allows the user to mark cells with icons that show the relationship between the cells' values. The related values can be numbers, percents or percentiles, or formulas, but for this example simple numbers will be used.
6/29/2012 1:55:58 AM
To show the relationship between data, data must exist first. Here is a simple list of numbers in Excel:
1. To add icons to these cells, select them with the mouse and click Conditional Formatting on the toolbar.
2. In the drop-down menu, mouse over Icon Sets and choose the desired icons. Click More Rules to set the criteria for the icon set.
3. Select a Rule Type, then edit the values of the rule's attributes using the fields in the bottom pane of the dialog.
For this example the "3 Symbols (Uncircled)" icon set has been used. The green check has been assigned to all values greater than or equal to 40, the yellow exclamation to values between 30 and 40, and the red X to values below 30.
4. Click OK.
Once applied to the selected cells, the icons will be displayed thusly:
Other Related Articles:
Microsoft Excel 2007: Filter by Cell Color, Font Color, or Icon set
Microsoft Excel 2007: Fill Colors
Microsoft Excel 2007: Filter for Above or Below Average Numbers
We love feedback! Please help us improve this article.