Excel symbols: Highlighting cells with icon sets

Excel symbols: YOUR OBJECTIVE

You can insert icons next to the values in the data range using the Conditional Formatting with Icon Sets to show whether the particular value is in the upper, medium or lower range of values.

Excel gives you the option to define three, four or five different value ranges and specify threshold values for each range. In this learning module “Excel symbols” you will learn how to highlight cells with icon sets and what you have to pay attention to.

Excel symbols: HOW DOES IT WORK?

Before you select an icon set, select the data range you want to highlight:

Then click the button in the Styles group on the Home tab to open the following drop-down menu:

Move your cursor over the command:

The corresponding submenu opens:

Icon sets with directional arrow icons that are either colored in red-yellow-green or gray. In the colored arrow section you can also select option 3 Triangles. Depending on the scaling, you can select three, four or five arrows. All values from the value range are matched to their corresponding scale.

You can select icons in the shape of traffic lights in the Shapes section. You can select between combinations of three or four icons in red-yellow-green with or without black, with or without border.

You can choose between three options in the Indicators section. You can set an encircled or a non-encircled checkmark, exclamation mark or an x. Alternatively, you can also set three flags.

Excel also offers the option of analyzing the corresponding cell contents more precisely. This can be done with a 3-step, 4-step or 5-step scale, or a scale within the analyzing icons.

When you move your mouse pointer over the respective icon sets, you can review the effects of your selection on the selected data in the live preview:

For instance, select the 3 traffic lights (with border) icon set by clicking it with your mouse:

Your selection is then applied to the previously selected data range:

Excel symbols: HINT

Click the Conditional Formatting button on the Home tab and select the Clear Rules command to delete a Conditional Formatting.

Excel symbols: CAUTION

Previous Excel versions do not support the Conditional Formatting with Icon Sets. Icons are not displayed when you open the file with a previous Excel version in the compatibility mode.

Did you like it? Then share it or sign up!

You can share this article with your friends or sign up for our newsletter for further information.

Leave a comment

Connect with Facebook

*

Kein Banner zum Anzeigen