This documentation is archived and is not being maintained.

IconSetCondition Interface

Represents an icon set conditional formatting rule.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

[GuidAttribute("00024497-0000-0000-C000-000000000046")]
[InterfaceTypeAttribute()]
public interface IconSetCondition

All conditional formatting objects are contained within a FormatConditions collection object, which is a child of a Range collection. You can create an icon set formatting rule by using either the Add(XlFormatConditionType, Object, Object, Object, Object, Object, Object, Object) method or AddIconSetCondition() method of the FormatConditions collection.

Each icon set contains three, four, or five icons. You use the IconSets property of the _Workbook object to return an IconSets object to specify one of the built-in icon sets. Each individual icon in the icon set is then assigned to a subset of the values of the range by the members of the IconCriteria obect. The type of threshold is also specified by this object.

Show: