2.5.15 CFOper
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 |
|---|---|---|
|
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. |
|
|
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. |
|
|
0x00000003 |
This rule evaluates to True (1) when the cell's value is equal to the value specified by rgce1. |
|
|
0x00000004 |
This rule evaluates to True (1) when the cell's value is not equal to the value specified by rgce1. |
|
|
0x00000005 |
This rule evaluates to True (1) when the cell's value is greater than the value specified by rgce1. |
|
|
0x00000006 |
This rule evaluates to True (1) when the cell's value is less than the value specified by rgce1. |
|
|
0x00000007 |
This rule evaluates to True (1) when the cell's value is greater than or equal to the value specified by rgce1. |
|
|
0x00000008 |
This rule evaluates to True (1) when the cell's value is less than or equal to the value specified by rgce1. |