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

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

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