Using Icon Sets in Excel

To create a table that displays a colored object rather than a value follow these steps:

1. Create a table.
2. If your table will be a yes or no then use either a zero or one as the value.
3. Select all values (zeros and ones).
   
4. Click on Conditional Formatting in the Home tab.
5. Move your cursor over Icon Sets and then select an Icon type.
6. To have only the icon displayed, click on Conditional Formatting in the Home tab
7. Click on Manage Rules.
8. Click on Edit Rules
9. Select the Show Icon Only check box in the lower right of the form.

Watch this video to see how it's done.