Cell Fill colours

[Guest]

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.

 

[Bob Phillips]

Excel has a colour palette of 56 colours. You can set any of these using
Tools>Options>Color>Modify. 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)

 

[Gord Dibben]

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