Share via

2.4.34 BrtBeginConditionalFormatting

  • Article

The BrtBeginConditionalFormatting record specifies conditional formatting properties for a range and specifies the beginning of a collection of records as defined by the Worksheet (section 2.1.7.62) part ABNF. The collection of records specifies conditional formatting information for a range.


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

fPivot

sqrfx (variable)

...

ccf (4 bytes): An unsigned integer that equals the count of BrtBeginCFRule (section 2.4.23) records contained in the collection.

fPivot (4 bytes):  A Boolean (section 2.5.98.3) that specifies whether the conditional formatting is applied only to a PivotTable (section 2.1.7.40). This value MUST be a value from the following table.

Value

Meaning

0x00000000

The area specified by sqrfx includes some cells that are not part of a PivotTable data area (section 2.2.5.3.8.1.4).

0x00000001

The area specified by sqrfx only includes cells that are part of a PivotTable data area (section 2.2.5.3.8.1.4).

sqrfx (variable): An UncheckedSqRfX (section 2.5.156) that specifies the range the conditional formatting applies to.