Color Property

Applies To

Border object, Borders collection object, Font object, Interior object.

Description

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 Long.

Object

Color

Border

The color of the border.


(continued)

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.


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)