Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Changing the Excel color palette
I want to be able to set the RGB value for a fill color in a macro. The
color palette does not have the soft pastels I want to use. The problem stems from the fact that changes to the color palette don't carry over if I open the worksheet on another computer. So using the ColorIndex(3) doesn't work. I would like to do something like ColorIndex(3)= RGB(223,156,78). Any ideas?? Thanks, Don |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Changing the Excel color palette
Don
Does Sub RGBColour() Range("A1").Interior.Color = RGB(223, 156, 78) End Sub Help? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Don McClure" wrote in message ... I want to be able to set the RGB value for a fill color in a macro. The color palette does not have the soft pastels I want to use. The problem stems from the fact that changes to the color palette don't carry over if I open the worksheet on another computer. So using the ColorIndex(3) doesn't work. I would like to do something like ColorIndex(3)= RGB(223,156,78). Any ideas?? Thanks, Don |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Changing the Excel color palette
I ran into the same problem very recently.
choose tools/option/color choose a color you don't want to use. click on Modify/standard choose the color you want to use click Ok I tried to use the RGB function, but Excel 2003 does some weird stuff with the RGB function. "Nick Hodge" wrote: Don Does Sub RGBColour() Range("A1").Interior.Color = RGB(223, 156, 78) End Sub Help? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Don McClure" wrote in message ... I want to be able to set the RGB value for a fill color in a macro. The color palette does not have the soft pastels I want to use. The problem stems from the fact that changes to the color palette don't carry over if I open the worksheet on another computer. So using the ColorIndex(3) doesn't work. I would like to do something like ColorIndex(3)= RGB(223,156,78). Any ideas?? Thanks, Don |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
excel 2003 changing saved print settings | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
I entered 11/22/2004 in excel workbook and it keeps changing to ## | Excel Worksheet Functions |