CONDFMT: Conditional Formatting Range Information (1B0h)

This record stores conditional formatting range information.

Record Data BIFF8

Offset

Name

Size

Contents

4

ccf

2

Number of conditional formats

6

grbit

2

Option flags

8

rwFirst

2

First row to conditionally format (0-based)

10

rwLast

2

Last row to conditionally format (0-based)

12

colFirst

2

First column to conditionally format (0-based)

14

colLast

2

Last column to conditionally format (0-based)

16

rgbSqref

var

Array of sqref structures


The grbit field contains the options listed in the following table.

Bits

Mask

Name

Contents

0

01h

fToughRecalc

= 1 if the appearance of the cell requires significant processing

15 – 1

FFFEh

(Reserved)

Reserved; must be 0 (zero)


The sqref structure stores a union of multiple areas on a worksheet. The sqref structure is shown in the following table.

Offset

Name

Size

Contents

0

irefMac

2

Number of areas that follow

2

reref

var

Array of ref structures


The ref structure is shown in the following table.

Offset

Name

Size

Contents

0

rwFirst

2

First row in the reference

2

rwLast

2

Last row in the reference

4

colFirst

2

First column in the reference

6

colLast

2

Last column in the reference