Color Property
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. |
expression.Color
expression Required. An expression that returns one of the objects in the Applies To list.
Example
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)