What it does
Uses conditional formatting to highlight the active cell, row, and column so you can more easily follow what selected.  Click once to toggle on and again to toggle off.

When to use it
When you want to easily see which cell, row, and column you have selected.

Why to use it
It’s a quick and easy way to toggle conditional formatting to easily see which cell, row, or column you have selected.

Default shortcut
None

Other Details

• Category: Productivity / Navigation
• Difficulty: 2/5
• Usage/frequency: 4/5
• Automation factor: 4/5 (estimated 60 seconds saved each time used)
• Type: Shortcut
• Date added: 10/14/2023
• Tags: track, active cell, column, row, selection, conditional formatting

Related Macros
None

Other Articles
None

None

Prerequisites
None

Instructions
Run the Toggle Cell Tracker macro.  It will add the necessary conditional formatting to the used range of the active sheet to highlight the active cell, row, and column.  Run the Toggle Cell Tracker macro again to turn it off and remove the conditional formatting.

If you need to update the range to apply to (likely because you’ve added data), simply toggle it off and on again.

Note that this will add some required VBA code to the active sheet to work so that it will update each time you change the selected cell.  To retain this code, save the file as a macro-enabled workbook, otherwise it will be deleted when you close the workbook.  If that’s the case, it’s okay – just toggle the Toggle Cell Tracker macro off and on again to re-add the code.