GrapeCity.Documents.Excel.IIconCriteria

IIconCriteria Interface

Represents the collection of IIconCriterion objects.

Each IIconCriterion represents the values and threshold type for an icon in an icon set conditional formatting rule.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface IIconCriteria

Public Interface IIconCriteria

Examples

worksheet.Range["A1:A5"].Value = new object[,] {{10}, {30}, {50}, {70}, {90}};
IIconSetCondition condition = worksheet.Range["A1:A5"].FormatConditions.AddIconSetCondition();
condition.IconSet = workbook.IconSets[IconSetType.Icon3Symbols];
IIconCriteria criteria = condition.IconCriteria;

Properties

Name	Description
Count	Gets the number of criteria in the icon set conditional formatting rule. This value indicates how many IIconCriterion objects are available in the IIconCriteria collection for the current icon set conditional formatting rule.
this[int]	Gets an IIconCriterion object from the collection. Each returned criterion represents the threshold settings for one icon in an icon set conditional formatting rule.

Name

Description

Count

Gets the number of criteria in the icon set conditional formatting rule.

This value indicates how many IIconCriterion objects are available in the IIconCriteria collection for the current icon set conditional formatting rule.

this[int]

Gets an IIconCriterion object from the collection.

Each returned criterion represents the threshold settings for one icon in an icon set conditional formatting rule.