TdxSpreadSheetConditionalFormattingRuleCellIs.ComparisonOperator Property

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

Declaration

property ComparisonOperator: TdxSpreadSheetConditionalFormattingRuleCellIsComparisonOperator read; write;

Property Value

Type	Description
TdxSpreadSheetConditionalFormattingRuleCellIsComparisonOperator	The active cell value evaluation mode.

Remarks

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

cicoEqual | cicoGreaterThan | cicoLessThan | cicoGreaterThanOrEqual | cicoLessThan | cicoLessThanOrEqual | cicoNotEqual

Value 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 | cicoNotBetween

Range 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.

Default Value

The ComparisonOperator property’s default value is cicoBetween.