Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

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

Show:
© 2014 Microsoft