GrapeCity.Documents.Excel.IFormatCondition.Operator

Operator Property

Operator

Gets or sets the operator of this conditional format.

The operator specifies how the conditional formatting rule compares the cell value with the rule's formula values. For example, it can indicate comparisons such as equal, greater than, or between.

Declaration

FormatConditionOperator Operator { get; set; }

Property [Operator] As FormatConditionOperator

Examples

worksheet.Range["A1:A3"].Value = new object[,] {{1}, {3}, {5}};
IFormatCondition condition = (IFormatCondition) worksheet.Range["A1:A3"]
    .FormatConditions.Add(FormatConditionType.CellValue, FormatConditionOperator.Between, "2", "4");
condition.Interior.Color = Color.Yellow;
FormatConditionOperator formatOperator = condition.Operator;