VBA Code use this Video.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ActiveSheet.Cells.Interior.ColorIndex = xlNone
Dim a As Integer
a = ActiveCell.Row
ActiveSheet.Rows(a).Interior.ColorIndex = 4
End Sub
VBA Code for Highlight Active Row in Excel.
Excel highlight active cell
VBA to highlight active row in ecxel.
highlight Active Row.
Simple way to highlight active cell or active row.
Highlight selected row orcolumn in excel.
How to highlight row when selecting a cell in excel.