Conditional line/arrow
 

Is it possible to have a line or arrow drawn between two cells if the amount
entered in one cell exceeds a control value in another cell?

Kind of...

I compared A1 with D10. I put a line from the drawing toolbar between these two
cells.

With that line selected, I typed a new name for it in the name box.
I called it: LineA1_D10
(just to distinguish it)

Then I rightclicked on that worksheet tab and selected view code. I pasted this
into the code window:

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then Exit Sub
If Intersect(Target, Me.Range("a1,d10")) Is Nothing Then Exit Sub

If Me.Range("a1").Value Me.Range("D10").Value Then
Me.Lines("lineA1_d10").Visible = True
Else
Me.Lines("LineA1_D10").Visible = False
End If
End Sub

And it worked fine if I changed the value in A1 or D10.

Ken G. wrote:

Is it possible to have a line or arrow drawn between two cells if the amount
entered in one cell exceeds a control value in another cell?

--

Dave Peterson