2.5.15 CFOper

  • Article

The CFOper enumeration specifies the valid types of value comparisons used in conditional formatting rules. The value of the cell is compared against the value calculated by using the formulas (section 2.2.2) stored in the rgce1 and rgce2 fields of the BrtBeginCFRule (section 2.4.23) record or in the FRTHeader field of the BrtBeginCFRule14 (section 2.4.24) record.

The value of this enumeration MUST be a value from the following table.

Name

Value

Meaning

CF_OPER_BN

0x00000001

This rule evaluates to True (1) when the cell's value is greater than or equal to the value specified by rgce1 and less than or equal to the value specified by rgce2.

CF_OPER_NB

0x00000002

This rule evaluates to True (1) when the cell's value is less than the value specified by rgce1 or greater than the value specified by rgce2.

CF_OPER_EQ

0x00000003

This rule evaluates to True (1) when the cell's value is equal to the value specified by rgce1.

CF_OPER_NE

0x00000004

This rule evaluates to True (1) when the cell's value is not equal to the value specified by rgce1.

CF_OPER_GT

0x00000005

This rule evaluates to True (1) when the cell's value is greater than the value specified by rgce1.

CF_OPER_LT

0x00000006

This rule evaluates to True (1) when the cell's value is less than the value specified by rgce1.

CF_OPER_GE

0x00000007

This rule evaluates to True (1) when the cell's value is greater than or equal to the value specified by rgce1.

CF_OPER_LE

0x00000008

This rule evaluates to True (1) when the cell's value is less than or equal to the value specified by rgce1.