Hi,

I want to make a cell a colour and I do this using Cell Fill on the Drawing
Toolbar, but there are only 40 colours to choose from, more than enough some
might say.

However, I've noticed in the Font Colour in Word there is a More Colours
option which lets you specify the Red, Green and Blue amounts.

How can I do the same in Excel?

Thanks.

Excel has a colour palette of 56 colours. You can set any of these using
ToolsOptionsColorModify. But that is it, although you could set another
colour in code say, excel will map it to the nearest applicable colour in
the palette.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"stuart" wrote in message
...
Hi,

I want to make a cell a colour and I do this using Cell Fill on the
Drawing
Toolbar, but there are only 40 colours to choose from, more than enough
some
might say.

However, I've noticed in the Font Colour in Word there is a More Colours
option which lets you specify the Red, Green and Blue amounts.

How can I do the same in Excel?

Thanks.

Note: Bob's suggestion for modifying colors is not a global change.

Workbook only, although you can copy the modofied color palette from one
workbook to another under "Copy colors from"

BTW there is a fill color Icon on the Formatting Toolbar. Looks like a
tipped-over paint can.


Gord Dibben MS Excel MVP


On Thu, 8 Mar 2007 06:29:30 -0800, stuart
wrote:

Hi,

I want to make a cell a colour and I do this using Cell Fill on the Drawing
Toolbar, but there are only 40 colours to choose from, more than enough some
might say.

However, I've noticed in the Font Colour in Word there is a More Colours
option which lets you specify the Red, Green and Blue amounts.

How can I do the same in Excel?

Thanks.