Gord,

Please correct me if i'm wrong, but you can not set a cell color to a color
that is not in XL's ColorIndex Color Pallette (pardon the
terminology....please correct).

I think I tried this once......tried to color a cell to an rgb value that
did not have an index # and XL adjusted it to the nearest color that was
assigned an index # (was using XL 2002 when I tried this, now using
2003...have not tried it).

Is that correct?

Thanks,

Conan




"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
ToolsOptionsColorModify will allow you change a color to any rgb value
you'd
like.

Or run a macro with your parameters.

Sub foo()
ActiveCell.Interior.Color = RGB(170, 112, 230)
End Sub


Gord Dibben MS Excel MVP

On Fri, 30 Nov 2007 17:11:00 -0800, zhj23

wrote:

Hello! Gurus

Is there a way to change the color of a cell to some specific RGB
combinations in addition to the standard color palette provided?

It would be good if we can add this special color to the palette for
future
use.

Thanks.

zhj23