View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default changing the color of a cell

As far as I know, you can't add, you can only replace. If you add a new
color it replaces one of the already existing colors.

--
Biff
Microsoft Excel MVP


"zhj23" wrote in message
...
Gord:

Thanks for the reply.

I prefer not to "modify", but "add" on to the color palette, so that I
will
not lose the standard colors.


zhj23

"Gord Dibben" wrote:

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