change a cell background colour to my own RGB colour requirements

's Computer Specifications

It would really nice if I could change a cell border and background coulour
to a specific RGB range for our company standard colour range. When preparing
quotations.

's Computer Specifications

dont know why, but you can't define your own colours in excel2000. Bu
if you define all your colours in text in msword, then just copy&paste
Your new colours should appear in all your colour options on the Forma
Cells pane, but not on the quick buttons on toolbar. Hope this help

--
gareth9
-----------------------------------------------------------------------
gareth93's Profile: http://www.excelforum.com/member.php...fo&userid=2657
View this thread: http://www.excelforum.com/showthread.php?threadid=55258

's Computer Specifications

You can change the color palette unde
tools...options...color...modify...custom

cheer

--
tony
-----------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...fo&userid=2107
View this thread: http://www.excelforum.com/showthread.php?threadid=55258

's Computer Specifications

... or you can use the RGB function in VBA

The advantage with the color pallette is that you can distribute th
revised pallette around the company so that everyone has access to th
correct colours.

I assume you would pdf the document before sending it out.

The advantage with the VBA option is that the colour wont change i
someone changes the pallette.

But there againg if the company changes its company colours you ca
change all the templates simply by changing the pallette.

have fun,
hope this help

--
tony
-----------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...fo&userid=2107
View this thread: http://www.excelforum.com/showthread.php?threadid=55258

's Computer Specifications

wow its that simple - Thank so much its a great help - Steve

"tony h" wrote:

>
> You can change the color palette under
> tools...options...color...modify...custom
>
> cheers
>
>
> --
> tony h
> ------------------------------------------------------------------------
> tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
> View this thread: http://www.excelforum.com/showthread...hreadid=552587
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change background colour of a row if a particular cell has a value	wolfey	Microsoft Excel Misc	1	3rd Aug 2009 12:45 PM
if cell colour is then change cell colour in range	=?Utf-8?B?dGlnZXI=?=	Microsoft Excel Programming	2	30th May 2007 05:32 AM
how do i change cell background colour depending on its content?	=?Utf-8?B?ZGVtYmxl?=	Microsoft Excel Misc	2	2nd May 2007 05:50 PM
if cell contains formula change background colour to pale yellow	Max Bialystock	Microsoft Excel Programming	2	28th May 2004 01:19 AM
Change Cell Background Colour	Terry	Microsoft Excel New Users	5	9th Apr 2004 03:01 AM