Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need to set a cell background color which is not within the Excel colorindex range
Is there a way to set the background color of a cell in another way than the
interior.colorindex property ? I need to set a very light red color, and the reds that Exel exposes within the colorindex range are too dark for this. I've tried to change the background color outside from a VB app with interior.color=....colornr but that results in Excel in other colors than VB normally does when using the same color numbers. Oscar |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
need to set a cell background color which is not within the Excel colorindex range
Oscar,
You could use Color=RGB(... but Excel will map that onto the equivalent ColorIndex anyway. What you can do instead is to change the colour in the colour palette. Goto menu ToolsOptions and select the Color tab, select the red colour, click the Modify button, select the Custom tab, and select the shade of red you want. OK it and the Red ColorIndex takes on that colour. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Oscar" wrote in message .nl... Is there a way to set the background color of a cell in another way than the interior.colorindex property ? I need to set a very light red color, and the reds that Exel exposes within the colorindex range are too dark for this. I've tried to change the background color outside from a VB app with interior.color=....colornr but that results in Excel in other colors than VB normally does when using the same color numbers. Oscar |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
need to set a cell background color which is not within the Excel colorindex range
Thanks Bob,
I've seen that it worked. Let's see whether the whole subject can be automated by VB/VBA. Oscar "Bob Phillips" schreef in bericht ... Oscar, You could use Color=RGB(... but Excel will map that onto the equivalent ColorIndex anyway. What you can do instead is to change the colour in the colour palette. Goto menu ToolsOptions and select the Color tab, select the red colour, click the Modify button, select the Custom tab, and select the shade of red you want. OK it and the Red ColorIndex takes on that colour. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Oscar" wrote in message .nl... Is there a way to set the background color of a cell in another way than the interior.colorindex property ? I need to set a very light red color, and the reds that Exel exposes within the colorindex range are too dark for this. I've tried to change the background color outside from a VB app with interior.color=....colornr but that results in Excel in other colors than VB normally does when using the same color numbers. Oscar |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
need to set a cell background color which is not within the Excel colorindex range
ActiveWorkbook.Colors(3) = RGB(242, 20, 20)
If you know the RGB values (I have to do it by trial and error), you are away<vbg -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Oscar" wrote in message .nl... Thanks Bob, I've seen that it worked. Let's see whether the whole subject can be automated by VB/VBA. Oscar "Bob Phillips" schreef in bericht ... Oscar, You could use Color=RGB(... but Excel will map that onto the equivalent ColorIndex anyway. What you can do instead is to change the colour in the colour palette. Goto menu ToolsOptions and select the Color tab, select the red colour, click the Modify button, select the Custom tab, and select the shade of red you want. OK it and the Red ColorIndex takes on that colour. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Oscar" wrote in message .nl... Is there a way to set the background color of a cell in another way than the interior.colorindex property ? I need to set a very light red color, and the reds that Exel exposes within the colorindex range are too dark for this. I've tried to change the background color outside from a VB app with interior.color=....colornr but that results in Excel in other colors than VB normally does when using the same color numbers. Oscar |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
need to set a cell background color which is not within the Excel colorindex range
Bob
Great little utility here.... http://no-nonsense-software.com/freeware/ RGBtoHEX 1.1a Gord Dibben XL2002 On Sat, 6 Dec 2003 00:12:48 -0000, "Bob Phillips" wrote: If you know the RGB values (I have to do it by trial and error), you are away<vbg |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
need to set a cell background color which is not within the Excel colorindex range
thank you Bob and Gord,
I've found the right RGB-value and successfully added it by coding. Oscar "Gord Dibben" <gorddibbATshawDOTca schreef in bericht ... Bob Great little utility here.... http://no-nonsense-software.com/freeware/ RGBtoHEX 1.1a Gord Dibben XL2002 On Sat, 6 Dec 2003 00:12:48 -0000, "Bob Phillips" wrote: If you know the RGB values (I have to do it by trial and error), you are away<vbg |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
need to set a cell background color which is not within the Excel colorindex range
Thanks Gord, I might just build my own Excel version <g
Bob "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Bob Great little utility here.... http://no-nonsense-software.com/freeware/ RGBtoHEX 1.1a Gord Dibben XL2002 On Sat, 6 Dec 2003 00:12:48 -0000, "Bob Phillips" wrote: If you know the RGB values (I have to do it by trial and error), you are away<vbg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Background Color for selected range | Excel Worksheet Functions | |||
How do I change background color of highlighted Excel range ? | Excel Discussion (Misc queries) | |||
tab.colorindex linked to cell color | Excel Worksheet Functions | |||
Excel should let me sort on cell background color | Setting up and Configuration of Excel | |||
How Do I change the background color of a cell in microsoft excel. | Excel Discussion (Misc queries) |