Addisional colors in Excell

[Guest]

I was wondering if there is any way to display the (more colors) color wheel
from Excel. Currenly I only get the block of 40 colors. Please advise.

jdc

 

[Bob Phillips]

You can't, not in current Excel.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Hank Scorpio]

You can't, not in current Excel.

Actually, you CAN, but you can only change one of the existing 56
colours in the workbook (including the 16 chart colours below the main
40 in the Format Cells dialog), not introduce more than 56 colours.

You can't do it through the Format -> Cells dialog, but you can go to
Tools-> Options -> Color, select the colour that you want to change,
and select [Modify]. This doesn't brng up the wheel, but rather a tab
dialog which allows you to set the colour in question to any RGB
value.

This will affect the current workbook only.

 

[Bob Phillips]

Actually, you CAN, but you can only change one of the existing 56
colours in the workbook (including the 16 chart colours below the main
40 in the Format Cells dialog), not introduce more than 56 colours.

Therefore you can't.

 

[Hank Scorpio]

Therefore you can't.

Bob, the OP asked "I was wondering if there is any way to display the
(more colors) color wheel", not "I was wondering whether there was any
way to increase the number of colours".

Granted their statement "Currenly I only get the block of 40 colors"
might have thrown some ambiguity in, but as to whether or not you can
display if not the colour wheel but a dialog with corresponding
functionality, yes, you can.

 

[Hank Scorpio]

Bob, the OP asked "I was wondering if there is any way to display the
(more colors) color wheel", not "I was wondering whether there was any
way to increase the number of colours".

I should have also mentioned that the button which launches the same
dialog as the one launched through Tools -> Options -> Colors ->
Modify in Excel is labelled "More Colors" in Word. I therefore thought
it not unresonable to guess that that was what s/he was actually
after.