Share via

SubtotalLabelForeColor Property

  • Article

Returns or sets the foreground color for subtotal labels in the specified field. Read/write Variant.

expression.SubtotalLabelForeColor

*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.

Applies to | PivotField Object

See Also | SubtotalLabelBackColor Property | SubtotalLabelFont Property | SubtotalLabelHAlignment Property