This documentation is archived and is not being maintained.

ColorFormat Object

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.


Represents the color of a one-color object, the foreground or background color of an object with a gradient or patterned fill, or the pointer color. You can set colors to an explicit red-green-blue value (by using the RGB property) or to a color in the color scheme (by using the SchemeColor property).

Using the ColorFormat Object

Use one of the properties listed in the following table to return a ColorFormat object.

Use this propertyWith this objectTo return a ColorFormat object that represents this
BackColorFillFormatThe background fill color (used in a shaded or patterned fill)
ForeColorFillFormatThe foreground fill color (or simply the fill color for a solid fill)
BackColorLineFormatThe background line color (used in a patterned line)
ForeColorLineFormatThe foreground line color (or just the line color for a solid line)
ForeColorShadowFormatThe shadow color
ExtrusionColorThreeDFormatThe color of the sides of an extruded object

Use the RGB property to set a color to an explicit red-green-blue value. The following example adds a rectangle to myDocument and then sets the foreground color, background color, and gradient for the rectangle's fill.

Set myDocument = Worksheets(1)
With myDocument.Shapes.AddShape(msoShapeRectangle, _
        90, 90, 90, 50).Fill
    .ForeColor.RGB = RGB(128, 0, 0)
    .BackColor.RGB = RGB(170, 170, 170)
    .TwoColorGradient msoGradientHorizontal, 1
End With