ColorFormat object (Excel)
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.
Remarks
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 property | With this object | To return a ColorFormat object that represents this color |
|---|---|---|
| BackColor | FillFormat | The background fill color (used in a shaded or patterned fill) |
| ForeColor | FillFormat | The foreground fill color (or simply the fill color for a solid fill) |
| BackColor | LineFormat | The background line color (used in a patterned line) |
| ForeColor | LineFormat | The foreground line color (or just the line color for a solid line) |
| ForeColor | ShadowFormat | The shadow color |
| ExtrusionColor | ThreeDFormat | The color of the sides of an extruded object |
Example
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
Properties
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.