Hi Bob.

I suspect that you intended something like:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A:A").Interior.ColorIndex = xlColorIndexNone

If Target.Column < 1 Then
Range("A" & Target.Row).Interior.ColorIndex = 6
End If
End Sub


---
Regards,
Norman



"Bob Phillips" wrote in message
...
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If target.column < 1 Then
Range("A" & Target.Row).Interior.ColorIndex = 6
Else
Range("A:A").Interior.ColorIndex = xlColorIndexNone
End If
End Sub

--
HTH

Bob Phillips

"boogie" wrote in message
...
Opps, i apologize to you both if my question was very clear. Actually, If
i
want to click on any cell from B to IV, the corresponding cell on A
should
be
highlighted. Let's say C1 is clicked, then A1 is highlighted. Again if
G10
is
clicked, then A10 is highlighted but of course the previous hightlighted
cell
in column A is go back to white. Something like what Helmut says,
"toggle".
thank you for trying to help. God bless.

"Helmut Weber" wrote:

Hi Bob,

it seems indeed the question is more a problem than the answer.

Something like, I want A1 highlighted with yellow color
everytime i click anywhere from B1 to IV1

If i move to anywhere on any cell,
i want the corresponding cell on A column be highlighted

Helmut Weber