2.5.56 CondFmtStructure

The CondFmtStructure structure specifies conditional formatting rules that are associated with a set of cells in a containing CondFmt12 record.


0


1


2


3


4


5


6


7


8


9

1
0


1


2


3


4


5


6


7


8


9

2
0


1


2


3


4


5


6


7


8


9

3
0


1

ccf

A

nID

refBound

...

sqref (variable)

...

ccf (2 bytes): An unsigned integer that specifies the count of CF12 records that follow the containing record. MUST be greater than or equal to 0x0001.

A - fToughRecalc (1 bit):  A bit that specifies that the appearance of the cell requires significant processing.  This information can be used to optimize the redraw of conditional formatting when data values change.

For example, an application could determine that a conditional formatting rule that contains certain functions or a conditional formatting rule that takes more than a predetermined amount of time to calculate designates that the conditional formatting requires significant processing, and could set this bit to 1.

nID (15 bits): An unsigned integer that identifies this record.

refBound (8 bytes): A Ref8U structure that specifies bounds of the set of cells to which the rules are applied.  The set of cells that it represents MUST include all of the cells represented by field sqref.

sqref (variable): A SqRefU structure that specifies the cells to which the conditional formatting rules apply. sqref.cref MUST be greater than zero and less than or equal to 1026.