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.
- First, choose Number from the Type dropdown.
- Only the 100's get an icon.
Tip: use the Icon dropdown shown above to build your own set of icons:
- The 5-icon cell phone power bars morphed into this.