auto highlight selected cell row and column in excel | Easy tutorial

Описание: auto highlight selected cell row and column in excel | Easy tutorial

Here's an VBA code for reference.
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
' Clear previous highlights
Cells.Interior.ColorIndex = 0

' Highlight entire active row and column
Target.EntireRow.Interior.Color = RGB(255, 255, 153) ' Light yellow for row
Target.EntireColumn.Interior.Color = RGB(255, 255, 204) ' Slightly lighter yellow for column

' Optional: highlight the active cell more strongly
Target.Interior.Color = RGB(255, 255, 102) ' Brighter yellow
End Sub

how to auto highlight active cell row and column in excel
automatically highlight active cell row and column in excel
highlight active cell & row in excel with click
highlight active row and column in excel (based on cell selection)
highlight active cell row & column in excel