Add Icons to Only the Good Cells
August 11, 2023 - by Bill Jelen

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.


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

This article is an excerpt from Power Excel With MrExcel
Title photo by Joanna Kosinska on Unsplash