FormatConditions.AddIconSetCondition Method
Returns a new IconSetCondition object which represents an icon set conditional formatting rule for the specified range.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Function AddIconSetCondition As Object
'Usage
Dim instance As FormatConditions
Dim returnValue As Object
returnValue = instance.AddIconSetCondition()
Object AddIconSetCondition()
Return Value
Type: System.Object
IconSetCondition object
Remarks
Use an icon set to annotate and classify data into three to five categories separated by a threshold value. Each icon represents a range of values. For example, in the 3 Arrows icon set, the red up arrow represents higher values, the yellow sideways arrow represents middle values, and the green down arrow represents lower values.