Excel cursor highlights row as you move throughout spreadsheet

[Guest]

How do I have the cursor highlight rows as I move through a spreadsheet?
Meaning the row I'm on is highlighted as I'm working on it and then
automatically becomes unhighlighted as I move off of it. The goal is for me
to be able to see the row all the way across as I'm working on it with have
to manually highlight the row and then turn if of when I'm off of the row.

 

[Gord Dibben]

Mejia

Download Chip Pearson's FREE RowLiner add-in.

http://www.cpearson.com/excel/RowLiner.htm

Gord Dibben Excel MVP

 

[Bob Phillips]

Here is one way

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.FormatConditions.Delete
With Target.EntireRow
.FormatConditions.Add Type:=xlExpression, Formula1:="TRUE"
With .FormatConditions(1)
With .Borders(xlTop)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 5
End With
With .Borders(xlBottom)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 5
End With
End With
.FormatConditions(1).Interior.ColorIndex = 20
End With

End Sub


'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.

 

[David]

Bob Phillips wrote

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.FormatConditions.Delete
With Target.EntireRow
.FormatConditions.Add Type:=xlExpression, Formula1:="TRUE"
With .FormatConditions(1)
With .Borders(xlTop)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 5
End With
With .Borders(xlBottom)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 5
End With
End With
.FormatConditions(1).Interior.ColorIndex = 20
End With

End Sub

Hmmm. Is there a way to limit it to a range within that row, i.e. columns I
through S?