SubtotalBackColor Property

Microsoft Office Web Components Object Model

SubtotalBackColor Property

       

Returns or sets the back color for the subtotal in the specified field. For subtotals, this property’s setting overrides the TotalBackColor property setting. Read/write Variant.

expression.SubtotalBackColor

expression   Required. An expression that returns a PivotField object.

Remarks

When you set this property, you can use either a Long value representing a red-green-blue color value or a String value naming a valid HTML color value. For example, to set the object color to red, you could use the hexadecimal value &HFF, the decimal value 255, or the string value "red." In Microsoft Visual Basic, you can use the RGB function to create a red-green-blue color value (red is RGB(255,0,0)).

This property always returns the color as a Long value representing a red-green-blue color value.