Edit

Share via

IconSetCondition.IconSet property (Excel)

  • Article

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

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.

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.