Code: Select all
=CELL("row")=ROW()
Code: Select all
=CELL("col")=COLUMN()
Code: Select all
=OR(CELL("row")=ROW(), CELL("col")=COLUMN())
Open VBA - ALT+F11
Code: Select all
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Target.Calculate
End Sub