From VBA Help (Colorindex):

Font The color of the font. Specify xlColorIndexAutomatic to use the
automatic color.

Interior The color of the interior fill. Set this property to
xlColorIndexNone to specify that you don't want an interior fill.



In article ,
"Frank" wrote:

I want to set the font color index of a cell
to 'automatic' and the fill color to 'no fill'.

I don't see the index number in the color chart in Excel's
help.

What are the Color Index #s for 'automatic' font and 'no
fill'

Thanks for your help