This article outlines a neat trick in how to code a very professional looking dynamic cursor in any table in excel using a short VBA macro and conditional formatting.
The following presentation trick can be achieved in just minutes using a combination of Named Ranges, VBA (Worksheet_SelectionChange) and Conditional Formatting (three conditions).
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
[RowSelection] = Target.Row
[ColumnSelection] = Target.Column
If you liked this trick, then you should read more about our VBA for Financiers course where this topic is discussed in detail.