Color Property

Microsoft Excel Visual Basic

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)