Color Property [Excel 2003 VBA Language Reference]

Returns or sets the primary color of the object, as shown in the following table. Use the RGB function to create a color value. Read/write Variant.

Object Color
Border The color of the border.
Borders The color of all four borders of a range. If they're not all the same color, Color returns 0 (zero).
Font The color of the font.
Interior The cell shading color or the drawing object fill color.
Tab The color of the tab.


expression Required. An expression that returns one of the objects in the Applies To list.


This example sets the color of the tick-mark labels on the value axis in Chart1.

Charts("Chart1").Axes(xlValue).TickLabels.Font.Color = _
    RGB(0, 255, 0)

Applies to | Border Object | Borders Collection | Font Object | Interior Object | Tab Object