Home |
Search |
Today's Posts |
#1
|
|||
|
|||
color options
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!!! |
#2
|
|||
|
|||
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 "Heather" skrev i melding ... 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!!! |
#3
|
|||
|
|||
Heather,
You are limited to a 56 colour palette, but you can modify any colour in the palette, ToolsOptionsColor - modify button. -- HTH RP (remove nothere from the email address if mailing direct) "Heather" wrote in message ... 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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|