How do I make lines appear after entering a number in a cell?

[Achilleas]

I am trying to make lines or shapes appear or disappear, depending on which
number I put in a cell. How do I do that please?

[Anne Troy]

Lines means borders? If so, Format-->Conditional formatting. Shapes? That
would have to be done with code.
************
Anne Troy
www.OfficeArticles.com

"Achilleas" <Achilleas@discussions.microsoft.com> wrote in message
news:5DA83EAF-1172-4DE1-9A7B-5864C32AEC61@microsoft.com...
>I am trying to make lines or shapes appear or disappear, depending on which
> number I put in a cell. How do I do that please?

[Achilleas]

Well I am trying to draw some shapes using lines basically from the draw
tool. I want to be able to change certain lines and make them appear or
dissapear or change place when a certain cell has a certain value in it. Is
that something that needs coding? IF yes where can I learn? I haven't used VB
before. Thank you.

"Anne Troy" wrote:

> Lines means borders? If so, Format-->Conditional formatting. Shapes? That
> would have to be done with code.
> ************
> Anne Troy
> www.OfficeArticles.com
>
> "Achilleas" <Achilleas@discussions.microsoft.com> wrote in message
> news:5DA83EAF-1172-4DE1-9A7B-5864C32AEC61@microsoft.com...
> >I am trying to make lines or shapes appear or disappear, depending on which
> > number I put in a cell. How do I do that please?
>
>
>