The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

ColorFormat Object

Office 2007
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).

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
BackColor FillFormatThe background fill color (used in a shaded or patterned fill)
ForeColor FillFormatThe foreground fill color (or simply the fill color for a solid fill)
BackColor LineFormatThe background line color (used in a patterned line)
ForeColor LineFormatThe foreground line color (or just the line color for a solid line)
ForeColor ShadowFormatThe shadow color
ExtrusionColor ThreeDFormatThe 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.

Visual Basic for Applications
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

Community Additions