Words of caution: I’m no VBA expert, use the code at your own risk.
Credits and References:
- Hightlight active row/column in Excel without using VBA?
- Force a screen update in Excel VBA
- Application.ScreenUpdating can dramatically speed up your code (please do not be misled by the title)
You can google more about how to apply VBA code in your Excel:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.ScreenUpdating = False
Application.CalculateFull ''// this forces all formulas to update
Application.ScreenUpdating = True
Then you can follow hstay’s answer (no need for F9).