Share via

2.4.28 BrtBeginColorScale

  • Article

The BrtBeginColorScale record specifies the beginning of a collection of records as defined by the Worksheet (section 2.1.7.62) part ABNF and the Macro Sheet (section 2.1.7.32) part ABNF. The collection of records specifies a color scale used in conditional formatting.

If this record is followed by two BrtCFVO (section 2.4.331) records and two BrtColor (section 2.4.334) records, this record specifies a two-color color scale. The first BrtCFVO specifies the cell value for the beginning of the color scale, and the second BrtCFVO specifies the cell value for the end of the color scale. The first BrtColor specifies the color for the beginning of the color scale, and the second BrtColor specifies the color for the end of the color scale.

If this record is followed by three BrtCFVO records and three BrtColor records, this record specifies a three-color color scale. The first BrtCFVO specifies the cell value for the beginning of the color scale, the second BrtCFVO specifies the cell value for the midpoint of the color scale, and the third BrtCFVO specifies the cell value for the end of the color scale. The first BrtColor specifies the color for the beginning of the color scale, the second BrtColor specifies the color for the midpoint of the color scale, and the third BrtColor specifies the color for the end of the color scale.