2.5.20 CFVOType14

The CFVOType14 enumeration specifies how the Conditional Formatting Value Object (CFVO) value is determined. In the following table, X represents a parameter value. If the FRTHeader.fFormula field of the containing BrtCFVO14 (section 2.4.332) record is equal to 1, X is the result of evaluating the formula (section 2.2.2). Otherwise, X is equal to the value of the numParam field of the containing BrtCFVO14 record. The value of this enumeration MUST be a value from the following table.

Name

Value

Meaning

CFVONUM_14

0x00000001

X

CFVOMIN_14

0x00000002

The minimum value from the range of cells that the conditional formatting rule applies to.

CFVOMAX_14

0x00000003

The maximum value from the range of cells that the conditional formatting rule applies to.

CFVOPERCENT_14

0x00000004

The minimum value in the range of cells that the conditional formatting rule applies to, plus X percent of the difference between the maximum and minimum values in the range of cells that the conditional formatting rule applies to.

For example, if the minimum and maximum values in the range are 1 and 10 respectively, and X is 10, the CFVO value is 1.9.

CFVOPERCENTILE_14

0x00000005

The minimum value of the cell that is in the X percentile of the range of cells that the conditional formatting rule applies to.

CFVOFMLA_14

0x00000007

The result of evaluating the formula of the containing BrtCFVO14 record.

CFVOAUTOMIN_14

0x00000008

The smaller of 0 or the minimum value from the range of cells that the conditional formatting rule applies to.

CFVOAUTOMAX_14

0x00000009

The larger of 0 or the maximum value from the range of cells that the conditional formatting rule applies to.