TdxSpreadSheetConditionalFormattingRuleCellIs.ComparisonOperator Property
In This Article
Specifies the Cell Is conditional formatting rule’s cell value comparison mode.
#Declaration
Delphi
property ComparisonOperator: TdxSpreadSheetConditionalFormattingRuleCellIsComparisonOperator read; write;
#Property Value
Type | Description |
---|---|
Tdx |
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.
See Also