Mouse point

[Guest]

hello,
i have a data A1:E10 now what i want if mouse point is in A1 then i want
highligh that row like A1:E1 same even if mouse would be in B1 need same high
lighting whole row A1:E1
thanks in advance

 

[PCLIVE]

Right-click on your worksheet tab and select View source. Then paste this
code and see if that does what you want. I'm sure there are other ways this
could be done.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Row < 11 And Target.Column < 6 _
Then
Range(Cells(Target.Row, 1), Cells(Target.Row, 5)).Select
Else
End If
End Sub

HTH,
Paul

 

[Guest]

Great ! that's what I was looking, now please can you let me know that how
can i put some color like green or yello A1:E1

 

[PCLIVE]

This is for the background of the cells. If you want to change the font
color, use .Font.ColorIndex = <color number>

If Target.Row < 11 And Target.Column < 6 _
Then
Range(Cells(Target.Row, 1), Cells(Target.Row, 5)).Select
With Selection.Interior
.ColorIndex = 6 '4 for green, 6 for yellow
End With
Else
End If

 

[Guest]

Thank you very much dear.

This is for the background of the cells. If you want to change the font
color, use .Font.ColorIndex = <color number>

If Target.Row < 11 And Target.Column < 6 _
Then
Range(Cells(Target.Row, 1), Cells(Target.Row, 5)).Select
With Selection.Interior
.ColorIndex = 6 '4 for green, 6 for yellow
End With
Else
End If