FormatConditions.AddIconSetCondition Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Returns a new IconSetCondition object which represents an icon set conditional formatting rule for the specified range.

public:
 System::Object ^ AddIconSetCondition();

public object AddIconSetCondition ();

Public Function AddIconSetCondition () As Object

Returns

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.

Applies to