Font.ColorIndex (Excel)

Returns or sets a value that represents the color of the font. Possible return values are xlColorIndexAutomatic - Automatic color, xlColorIndexNone - No color.

The color is specified as an index value into the current color palette, or as one of the following XlColorIndex constants: xlColorIndexAutomatic or xlColorIndexNone.

ActiveCell.Font.ColorIndex = xlColorIndexAutomatic