Font.Color property (Excel)
Returns or sets the primary color of the object, as shown in the table in the remarks section. Use the RGB function to create a color value. Read/write Variant.
Syntax
expression.Color
expression An expression that returns a Font object.
Remarks
| 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. |
Example
This example sets the color of the tick-mark labels on the value axis on Chart1.
Charts("Chart1").Axes(xlValue).TickLabels.Font.Color = _
RGB(0, 255, 0)
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.