TdxSpreadSheetConditionalFormattingRuleCellIsComparisonOperator Enum

Enumerates available criteria under which a Cell Is conditional formatting rule applies custom formatting to cells within the affected areas.

Declaration

TdxSpreadSheetConditionalFormattingRuleCellIsComparisonOperator = (
    cicoBetween,
    cicoEqual,
    cicoGreaterThan,
    cicoGreaterThanOrEqual,
    cicoLessThan,
    cicoLessThanOrEqual,
    cicoNotBetween,
    cicoNotEqual
);

Members

Name
cicoBetween
cicoEqual
cicoGreaterThan
cicoGreaterThanOrEqual
cicoLessThan
cicoLessThanOrEqual
cicoNotBetween
cicoNotEqual

Remarks

Options include:

Value	Description	Example (Expression = ‘=200’, Expression2 = ‘=700’)
cicoBetween	A “Cell Is” conditional formatting rule applies custom formatting to those affected cells whose values are within the range between results of formula expressions assigned to the Expression and Expression2 properties, inclusive. Alternatively, you can use a numeric value instead of either expression. The cicoBetween mode complements cicoNotBetween.
cicoEqual	A rule applies custom formatting only to those affected cells whose values are equal to: A calculated result of a formula expression assigned to the rule’s Expression property. A specific numeric value assigned to this property. If the Expression property value is not a numeric value or a valid formula expression, the conditional formatting controller interprets the value as a text string. The rule formats only those affected cells that contain the identical string value. The cicoEqual mode complements cicoNotEqual. The conditional formatting controller ignores the Expression2 property value in both complementary modes.
cicoGreaterThan	A rule applies custom formatting to those affected cells whose values exceed the calculated result of a formula expression assigned to the Expression property. Alternatively, you can assign a numeric value to the property instead of an expression. The cicoGreaterThan mode complements cicoLessThan. The conditional formatting controller ignores the Expression2 property value in both complementary modes.
cicoGreaterThanOrEqual	A rule applies custom formatting to those affected cells whose values are equal to or greater than the calculated result of a formula expression assigned to the Expression property. Alternatively, you can assign a numeric value instead of an expression. The cicoGreaterThanOrEqual mode complements cicoLessThanOrEqual, except for the comparison threshold (the Expression property value). The rule precedences determine formatting applied to the same affected cells that contain the threshold value if two “Cell Is” rules affect the same area(s). The conditional formatting controller ignores the Expression2 property value in both complementary modes.
cicoLessThan	A rule applies custom formatting to those affected cells whose values are lower than the calculated result of a formula expression assigned to the Expression property. Alternatively, you can assign a numeric value to the property instead of an expression. The cicoLessThan mode complements cicoGreaterThan. The conditional formatting controller ignores the Expression2 property value in both complementary modes.
cicoLessThanOrEqual	A rule applies custom formatting to those affected cells whose values are equal to or lower than the calculated result of a formula expression assigned to the Expression property. Alternatively, you can assign a numeric value instead of an expression. The cicoLessThanOrEqual mode complements cicoGreaterThanOrEqual, except for the comparison threshold (the Expression property value). The rule precedences determine formatting applied to the same affected cells that contain the threshold value if two Cell Is rules affect the same areas. The conditional formatting controller ignores the Expression2 property value in both complementary modes.
cicoNotBetween	A rule applies custom formatting to those affected cells whose values are strictly outside the range between the calculated results of formula expressions assigned to the Expression and Expression2 properties. Alternatively, you can use a numeric value instead of either expression. The cicoNotBetween mode complements cicoBetween.
cicoNotEqual	A rule applies custom formatting only to those affected cells whose values are not equal to: A calculated result of a formula expression assigned to the rule’s Expression property. A specific numeric value assigned to this property. If the Expression property value is not a numeric value or a valid formula expression, the conditional formatting controller interprets the value as a text string. The rule formats all cells that do not contain this string. The cicoNotEqual mode complements cicoEqual. The conditional formatting controller ignores the Expression2 property value in both complementary modes.

Direct TdxSpreadSheetConditionalFormattingRuleCellIsComparisonOperator Type Reference

The Cell Is conditional formatting rule’s ComparisonOperator property references the TdxSpreadSheetConditionalFormattingRuleCellIsComparisonOperator type.