How to Highlight Rows in Excel Dynamically with VBA

Описание: Learn how to automatically highlight an entire row in Excel using simple VBA code. This technique helps you make your data more readable by changing row colors based on cell values or user selection. Perfect for dynamic dashboards, reports, and smart excel sheets!

Dim lastRow As Range

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
' If there is a previously highlighted row, remove the highlight
If Not lastRow Is Nothing Then
lastRow.Interior.ColorIndex = -4142 ' Remove the color (no fill)
End If

' Highlight the entire row of the selected cell
Target.EntireRow.Interior.Color = RGB(255, 255, 0) ' Yellow color for the selected row

' Save the current selected row to remove highlight later
Set lastRow = Target.EntireRow
End Sub