TdxSpreadSheetConditionalFormattingRuleCellIs.ComparisonOperator Property

Specifies the Cell Is conditional formatting rule’s cell value comparison mode.

Declaration

delphi

property ComparisonOperator: TdxSpreadSheetConditionalFormattingRuleCellIsComparisonOperator read; write;

Type	Description
TdxSpreadSheetConditionalFormattingRuleCellIsComparisonOperator

The active cell value evaluation mode.

Use the ComparisonOperator property to switch between available cell evaluation modes.

cicoEqual | cicoGreaterThan | cicoLessThan | cicoGreaterThanOrEqual | cicoLessThan | cicoLessThanOrEqual | cicoNotEqualValue Comparison Mode. The rule compares the values of all affected cells to the calculated result of a formula expression assigned to the Expression property. The Expression2 property value is ignored.cicoBetween | cicoNotBetweenRange Comparison Mode. The rule checks if the values of all affected cells are within or outside a specific range. Expressions assigned to Expression and Expression2 properties define the value range for comparison.

Refer to the TdxSpreadSheetConditionalFormattingRuleCellIsComparisonOperator type description for detailed information on individual comparison modes.

The ComparisonOperator property’s default value is cicoBetween.