You can set it to any color you want - but Excel will convert it to one of
the 56 colors defined in the palette.
In excel help under worksheet and workbook specifications:
Colors in a workbook 56
That said, you can set any of the 56 colorindexes to any one of the RGB
colors (modify the palette). So you can have any color you want in the
cell, but within all the cells, you are limited to a total of 56 different
colors.
--
Regards,
Tom Ogilvy
wrote in message
oups.com...
Thanks alok. But then why does microsoft imply you can?? On this page:
http://office.microsoft.com/en-us/as...366271033.aspx
They set it to a color thats not in the Palette [RGB(200,160,35)] ??
I have also found numerous other sites that say you can set it to any
color you wish using interior.color = RGB(int, int, int)
Are they all wrong??