Enhanced icon set conditional formatting features in Excel2010

Starting with Excel 2007, new features such as data bars, levels, and icon sets are added to Excel conditional formatting to visually view and analyze data. Excel 2010 further enhances or improves these conditional formatting features to make it easier to use. The following are several features of enhanced or improved icon set conditional formatting in Excel 2010.

One, added 3 kinds of icon style

The set of icons in Excel 2007 has the icon style in 17, and Excel 2010 adds 3 icon styles, namely 3 triangles, 3 levels, and 5 boxes. and further subdivided the categories, such as "direction", "shape", "Mark" and so on.

The following figure is the icon set style in Excel 2007:

This is the icon set style in Excel 2010, and the blue border marks the new style:

Second, in the dialog box to select the icon style more intuitive

If you want to modify the icon set conditional formatting through the Edit Formatting Rules dialog box, you can see that Excel 2010 visually displays various styles when you select the icon set style in the dialog box, rather than the icon style name in Excel 2007.

The Edit Formatting Rule dialog box is opened by selecting a range that contains the conditional formatting of an icon set, on the Start tab, in the Styles group, click conditional formatting → administrative rules, and in the conditional Formatting Rules Manager, select double-click a rule.

Three, custom cell icon

The custom icon here is not to apply the icon you designed to the icon set conditional format, but instead use the different icon styles built into Excel for the same area. When you use an icon set conditional format, you sometimes need to set an icon for only some cells, not an icon for others, or a different icon style for some cells, as shown in the following illustration:

In the diagram, the four-color traffic lights icon style is set for column D, and a different icon style "green check symbol" is set for some of the larger values, and for smaller values, the icons in the cells are hidden, which makes them look more eye-catching.

The method you set is to select an icon in the Edit Formatting Rule dialog box by clicking the Drop-down arrow next to the button on the left of the rule, and if you select No cell icon, the cell icon is hidden.