| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change the colour of a line
Hi,
I have a line on a worksheet and I would like to change the colour dependent on a cell. How do I do the €˜change line colour part from say red to green. Any help greatly appreciated. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to change the colour of a line
Assume were are not talking about borders on cells, but a line from the
drawing toolbar: activesheet.Shapes("Line 1").Line.ForeColor.RGB = _ Range("B9").Interior.Color -- Regards, Tom Ogilvy "Chris" wrote: Hi, I have a line on a worksheet and I would like to change the colour dependent on a cell. How do I do the €˜change line colour part from say red to green. Any help greatly appreciated. Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to change the colour of a line
Thanks Tom
"Tom Ogilvy" wrote: Assume were are not talking about borders on cells, but a line from the drawing toolbar: activesheet.Shapes("Line 1").Line.ForeColor.RGB = _ Range("B9").Interior.Color -- Regards, Tom Ogilvy "Chris" wrote: Hi, I have a line on a worksheet and I would like to change the colour dependent on a cell. How do I do the €˜change line colour part from say red to green. Any help greatly appreciated. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cut and paste line filled with colour | Excel Discussion (Misc queries) | |||
| change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
| Line colour of .SeriesCollection.NewSeries? | Excel Programming | |||
| Colour part of a line on an X Y graph | Charts and Charting in Excel | |||
| How do I change the colour of/remove the Freeze Panes line in Exce | Excel Worksheet Functions | |||
Linear Mode
