IconSetCondition.IconSet Property (Excel)

Returns or sets an IconSets collection, which specifies the icon set used in the conditional format.

Version Information

Version Added: Excel 2007

Syntax

expression .IconSet

expression A variable that represents an IconSetCondition object.

Remarks

You can assign the icon set by using the IconSets property of the Workbook object. For example, Selection.FormatConditions(1).IconSet = ActiveWorkbook.IconSets(xl3TrafficLights1) will apply the three-traffic-light icon set to the conditional format.

See Also

Concepts

IconSetCondition Object

IconSetCondition Object Members