Excel: Add Icons to Only the Good Cells

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Problem: I want to mark only the best (or worst) cells with an icon. Everything else should not be marked with any icon.

Strategy: Say that you want to add a gold star to all scores of 100.

First, you set up a three-icon set. Edit the Rule. In the Figure below, you make sure the Gold Star is for a Number >=100. Change the icon for the next two rules to No Cell Icon.

  1. First, choose Number from the Type dropdown.

  2. Only the 100's get an icon.

    Tip: use the Icon dropdown shown above to build your own set of icons:

  3. The 5-icon cell phone power bars morphed into this.

For more resources for Microsoft Excel