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

• Application
• Brightness
• Creator
• ObjectThemeColor
• Parent
• RGB
• SchemeColor
• TintAndShade
• Type

See also

• Excel Object Model Reference

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.