If you change your setting for the window font color in the windows (not
excel) settings, it changes the color in the cells that are set for
xlautomatic - so it isn't necessarily the black(ish) font color.

--
Regards,
Tom Ogilvy

"Bob Phillips" wrote in message
...
It is the black(ish) font colour, but presumably as it is called automatic
it can be changed, or MS have reserved the option to make it configurable.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bill" wrote in message
ink.net...
Thanks, but I want to know the color that is represented by the
xlColorIndexAutomatic. How do I do that?


"Vasant Nanavati" <vasantn AT aol DOT com wrote in message
...
-4105 is the constant represented by xlColorIndexAutomatic. If you
want
the color to be blue try to set it specifically.

--

Vasant


"Bill" wrote in message
ink.net...
Hello,
I have a bar chart is made and then updated. For some reason, when
updating, the color changes from blue to purple. When I ask what the
color index is for the bar, prior to updating, I get -4105. Not the
color index I would expect for blue. I used:

Activechart.seriescollection(1).interior.colorinde x

Any ideas on what is happening? Is the -4105 some default setting?

Thanks,

Bill