Add Icons to Only the Good Cells
August 11, 2023 - by Bill Jelen
![Add Icons to Only the Good Cells Add Icons to Only the Good Cells](/img/excel-tips/2023/08/add-icons-to-only-the-good-cells.jpg)
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.
![Set the gold star to appear for greater than or equal to 100 number. For the next two icons, open the icon drop-down and choose No Cell Icon.](/img/content/2023/08/LE1468.png)
![Only the 100's in this grid have a gold star. All the other numbers, even 99's get no icon.](/img/content/2023/08/LE10001146.jpg)
Tip: use the Icon dropdown shown above to build your own set of icons:
![An icon set that mixes Green Arrow, with Green Triangle, Yellow Dash, Red Triangle, and Red Arrow.](/img/content/2023/08/LE1469.png)
This article is an excerpt from Power Excel With MrExcel
Title photo by Joanna Kosinska on Unsplash