Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Interior.ColorIndex = xlNone Rows(Target.Row).Interior.ColorIndex = 40 Columns(Target.Column).Interior.ColorIndex = 40 End Sub