How to change the colour of a line

G

Guest

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
 
G

Guest

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
 
G

Guest

Thanks Tom


Tom Ogilvy said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Colour code dates 1
Excel How to change lines in graph to individual colours 0
Excel Conditioning Formatting 3
Cell colour format according to date 1
Changing the Colour of a Line with VBA? 1
Excel 2007 VBA shape fill colour problem 4
Conditional formatting with vba 3
Colour format code 2

Top