GrapeCity.Documents.Excel.IIconCriterion.Operator

Operator Property

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.

Declaration

FormatConditionOperator Operator { get; set; }

Property [Operator] As FormatConditionOperator

Examples

IIconSetCondition condition = worksheet.Range["A1:A5"].FormatConditions.AddIconSetCondition();
condition.IconSet = workbook.IconSets[IconSetType.Icon3Symbols];
IIconCriterion criterion = condition.IconCriteria[1];
criterion.Operator = FormatConditionOperator.GreaterEqual;
FormatConditionOperator formatOperator = criterion.Operator;