GrapeCity.Documents.Excel.IIconCriterion

IIconCriterion Interface

Represents the criterion for an individual icon in an icon set.

The criterion specifies the range of values and the threshold type associated with the icon in an icon set conditional formatting rule. Each IIconCriterion defines the threshold settings for one icon, including its icon, comparison operator, threshold type, threshold value, and position within the icon set.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface IIconCriterion

Public Interface IIconCriterion

Examples

IIconSetCondition condition = worksheet.Range["A1:A5"].FormatConditions.AddIconSetCondition();
condition.IconSet = workbook.IconSets[IconSetType.Icon3Symbols];
IIconCriterion criterion = condition.IconCriteria[1];
criterion.Type = ConditionValueTypes.Number;
criterion.Value = 50;

Properties

Name	Description
Icon	Gets or sets the IconType value for a criterion in an icon set conditional formatting rule. Use this property to retrieve the icon currently assigned to a specific threshold in an icon set rule.
Index	Gets the zero-based index of this criterion in its parent IIconCriteria collection. Use this property to identify the position of an icon criterion within an icon set conditional formatting rule.
Operator	Returns one of the constants of the FormatConditionOperator enumeration,which specifies whether the threshold is "greater than" or "greater than or equal to" the threshold value. For an icon set conditional formatting rule, the returned value indicates how this criterion compares cell values against its threshold.
Type	Returns one of the constants of the ConditionValueTypes enumeration, which specifies how the threshold value for an icon set is determined. Use this property to inspect whether the criterion threshold is interpreted as a number, percent, percentile, formula, or another supported condition value type.
Value	Gets or sets the threshold value for an icon in a conditional format. The assigned value becomes the threshold for this icon criterion, such as a number, percentage, percentile, or formula value, depending on the criterion type.