Excel.IconSetCondition.IconSet.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
IconSetCondition.IconSet property (Excel)	vbaxl10.chm812087	vbaxl10.chm812087	Excel.IconSetCondition.IconSet	8e0529d5-1c15-744e-2391-7229bcbcd043	04/27/2019	medium

IconSetCondition.IconSet property (Excel)

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.

[!includeSupport and feedback]