Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
conditional formatting conflict? | Excel Worksheet Functions | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |