Hi Frank,

You could record a macro to see what it does...I did it and you get a value
of xlAutomatic and xlNone. These correspond to numeric values of -4105
and -4142 respectively.

Hope this helps,
Daniel

Excel Tips and Tricks - www.danielklann.com


"Frank" wrote in message
...
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