Edit

Share via

FormatConditions.AddIconSetCondition method (Excel)

  • Article

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

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.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.