Highlight selected row / column

Post by **eazy** » Thu Apr 25, 2024 6:54 am

Row

=CELL("row")=ROW()

Column

Code: Select all

=CELL("col")=COLUMN()

Row and Column

Code: Select all

=OR(CELL("row")=ROW(), CELL("col")=COLUMN())

Auto-refresh (in VBA)
Open VBA - ALT+F11

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
	Target.Calculate
End Sub