GrapeCity.Documents.Excel.IFormatConditions.AddIconSetCondition

AddIconSetCondition Method

AddIconSetCondition()

Returns a new IIconSetCondition object which represents an icon setconditional formatting rule for the specified range.

Use the returned rule to choose an icon set and configure the threshold criteria that determine which icon is displayed for each cell value.

Declaration

IIconSetCondition AddIconSetCondition()

Function AddIconSetCondition() As IIconSetCondition

Returns

Type	Description
IIconSetCondition	A new IIconSetCondition object.

Examples

IRange range = worksheet.Range["A1:A5"];
range.Value = new object[,] {{1}, {2}, {3}, {4}, {5}};
IIconSetCondition condition = range.FormatConditions.AddIconSetCondition();
condition.IconSet = workbook.IconSets[IconSetType.Icon3Symbols];
condition.IconCriteria[1].Value = 50;