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.

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. — Figure 1268. First, choose Number from the Type dropdown.

Only the 100's in this grid have a gold star. All the other numbers, even 99's get no icon. — Figure 1269. Only the 100’s get an icon.

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. — Figure 1270. The 5-icon cell phone power bars morphed into this.

This article is an excerpt from Power Excel With MrExcel

Title photo by Joanna Kosinska on Unsplash