#1   Report Post  
Heather
 
Posts: n/a
Default 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   Report Post  
Harald Staff
 
Posts: n/a
Default

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   Report Post  
Bob Phillips
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 02:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"