Font.ColorIndex procedure builder

Font.ColorIndex (Excel)

Returns or sets a value that represents the color of the font.

Possible 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