IconSetCondition.IconSet property (Excel)

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



expression A variable that represents an IconSetCondition object.


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.