Share via


FormatConditions.AddIconSetCondition Method

Excel Developer Reference

Returns a new IconSetCondition object which represents an icon set conditional formatting rule for the specified range.

Version Information
 Version Added:  Excel 2007

Syntax

expression.AddIconSetCondition

expression   A variable that represents a FormatConditions object.

Return Value
IconSetCondition object

Remarks

Use an icon set to annotate and classify data into three to five categories separated by a threshold value. Each icon represents a range of values. For example, in the 3 Arrows icon set, the red up arrow represents higher values, the yellow sideways arrow represents middle values, and the green down arrow represents lower values.

See Also