2.5.27 CFExNonCF12

The CFExNonCF12 structure specifies properties that extend a conditional formatting rule that is specified by a CF record.

icf (2 bytes): An unsigned integer that specifies a zero-based index of a CF record in the collection of CF records directly following the CondFmt record that is referenced by the parent CFEx record with the nID field.  The referenced CF specifies the conditional formatting rule to be extended.

cp (1 byte): An unsigned integer that specifies the type of comparison operation to use when the ct field of the CF record referenced by the icf field of this structure is equal to 0x01. MUST be zero when the ct field of the CF record is not equal to 1. SHOULD<154> be equal to the cp field in the referenced CF record.

In the following table, v represents the cell value, and v1 and v2 represent the results of evaluating the formulas specified by rgce1 and rgce2 fields of the referenced CF record specified by icf. The value of this field MUST be a value from the following table:

Value	Comparison Operation
0x00	No comparison
0x01	v2 is greater than or equal to v1, and v is greater than or equal to v1 and less than or equal to v2 –Or– v1 is greater than v2, and v is greater than or equal to v2 and less than or equal to v1
0x02	v2 is greater than or equal to v1, and v is less than v1 or greater than v2 –Or– v1 is greater than v2, and v is less than v2 or greater than v1
0x03	v is equal to v1
0x04	v is not equal to v1
0x05	v is greater than v1
0x06	v is less than v1
0x07	v is greater than or equal to v1
0x08	v is less than or equal to v1

icfTemplate (1 byte):  An unsigned integer that specifies the template from which the rule was created.  MUST be the least significant byte of one of the valid values specified for the icfTemplate field in the CF12 record.

ipriority (2 bytes):  An unsigned integer that specifies the priority of the rule.  Rules that apply to the same cell are evaluated in increasing order of ipriority. MUST be unique across all CF12 records and CFExNonCF12 structures in the worksheet substream.

A - fActive (1 bit): A bit that specifies whether the rule is active.  If set to zero, the rule will be ignored.

B - fStopIfTrue (1 bit): A bit that specifies whether, when a cell fulfills the condition corresponding to this rule, the lower priority conditional formatting rules that apply to this cell are evaluated. MUST be one of the following values:

Value	Meaning
0x0	Evaluate lower priority conditional formatting rules that apply to this cell
0x1	If the cell fulfills the condition corresponding to this rule, do not evaluate lower priority conditional formatting rules that apply to this cell

C - reserved1 (1 bit): MUST be zero and MUST be ignored.

D - unused (1 bit): Undefined and MUST be ignored.

E - reserved2 (4 bits): MUST be zero and MUST be ignored.

fHasDXF (1 byte):  A Boolean (section 2.5.14) that specifies whether cell formatting data is part of this record extension.  MUST be a value from the following table:

Value	Meaning
0x00	No formatting data in this record extension.
0x01	Formatting data is part of this record extension.

dxf (variable): A DXFN12 structure that specifies the format to use for cells that satisfy the condition.  MUST NOT be present when fHasDXF is zero.

cbTemplateParm (1 byte): An unsigned integer that specifies the size of the rgbTemplateParms field in bytes.  MUST be equal to 16.

rgbTemplateParms (16 bytes): A CFExTemplateParams that specifies parameters for the rule specified by this structure.