Excel cursor highlights row as you move throughout spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
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
Click to expand...

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