update for rowliner add-in

[nigelk2]

There's an excel add-in called Rowliner which has exactly the functionality I'm after. Unfortunately it doesn't work for 64 bit machines. Can anyone advise if there's an up to date solution for this?

Thanks

RowLiner Add-In

 

[Candyman8019]

You can do something similar by adding the following code to your sheet:

Private Sub Worksheet_SelectionChangeold2(ByVal target As Range)
If Application.CutCopyMode = False Then
On Error Resume Next
Application.Calculate
End If
End Sub

and then using conditional formatting on the desired range with this formula to highlight the selected row: =CELL("row")=ROW()
or this formula to highlight the selected row and column: =OR(CELL(“col”)=COLUMN(),CELL(“row”)=ROW())