Highlight Row for Entire and other workbooks

ShazSh 

The code would need to remember xRow for each sheet separately. If you are on Windows, you could copy the following code into the ThisWorkbook module of your personal macro workbook PERSONAL.XLSB (or of an add-in). Restart Excel after that. Make sure that you save PERSONAL.XLSB when prompted to do so.

Dim WithEvents app As Application
Dim dct As Object

Private Sub app_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
    If GetDct.Exists(Sh) Then
        With Sh.Rows(GetDct(Sh)).Interior
            .ColorIndex = xlNone
        End With
    End If

    GetDct(Sh) = Target.Row
    With Sh.Rows(Target.Row).Interior
        .ColorIndex = 3
        .Pattern = xlSolid
    End With
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    Set app = Nothing
    Set dct = Nothing
End Sub

Private Sub Workbook_Open()
    Set app = Application
End Sub

Private Function GetDct() As Object
    If dct Is Nothing Then
        Set dct = CreateObject("Scripting.Dictionary")
    End If
    Set GetDct = dct
End Function