Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

FormatConditions.AddIconSetCondition Method

Office 2007
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.




Community Additions

ADD
Show:
© 2015 Microsoft