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.

To show the relationship between data, data must exist first. Here is a simple list of numbers in Excel:

Numerical Cells

1. To add icons to these cells, select them with the mouse and click Conditional Formatting on the toolbar.

Conditional Formatting

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.

Edit Rule

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:

Cells with Icons

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

6/29/2012 1:55:58 AM  

We love feedback! Please help us improve this article.

Article Rating:
Email Address:
(Optional, unless you would like to hear back from us)
GROK is a resource of Louisiana State University developed and maintained with support of the LSU Student Technology Fee.  We love getting feedback from the general public, but our one on one support efforts are generally dedicated to the LSU community.  Thanks for your understanding!
"" ""

Information Technology Services
200 Frey Computing Center · Baton Rouge, LA 70803
Telephone: 225-578-3700 · Fax: 225-578-6400 · E-mail:

Copyright © 2006. All Rights Reserved. Official Webpage of Louisiana State University.