How to change the colour of a line

's Computer Specifications

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

's Computer Specifications

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
>

's Computer Specifications

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
> >

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change Line Colour Programatically in a Report	Simon	Microsoft Access Reports	1	18th Nov 2008 12:06 PM
gradual colour change of a line	=?Utf-8?B?UGF0IGF0IEp1aWNl?=	Microsoft Powerpoint	7	13th Oct 2007 08:06 PM
How do I change default line colour of a line connector in PPT?	=?Utf-8?B?TmV3YmllOTk=?=	Microsoft Powerpoint	1	21st Mar 2006 11:09 AM
Can you change connector line colour in organisation chart if you.	=?Utf-8?B?a2F0aXlfYWxsYW4=?=	Microsoft Powerpoint	1	8th Mar 2005 04:04 AM
How to change the default graph line colour settings	=?Utf-8?B?Unlhbg==?=	Microsoft Powerpoint	1	17th Oct 2004 04:07 AM