color options

H

Heather

There is a very limited selection of colors for fill and text for that
matter. I'm looking to change the fill to a specific RGB color. Please advise
if this is possible

Thanks!!!
 
H

Harald Staff

Hi

Yes, possible. You are limited to 56 colors, and what you color with is a
color number from 1 to 56. Those 56 can be customized for each single file.
This RGB thing is easiest achieved with macro code, like this demo altering
color 45:

Sub test()
ThisWorkbook.Colors(45) = RGB(234, 251, 178)
Selection.Interior.ColorIndex = 45
End Sub

HTH. Best wishes Harald
 
B

Bob Phillips

Heather,

You are limited to a 56 colour palette, but you can modify any colour in the
palette, Tools>Options>Color - modify button.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top