How to Highlight Active Row, Column & Cell in Excel (3 Colors)
Learn how to highlight the active row, column, and cell in Excel using 3 different colors.
This method uses Conditional Formatting formulas and a simple VBA fix so the highlight updates when you click.
📌 Formulas
Highlight active row:
=ROW()=CELL("row")
Highlight active column:
=COLUMN()=CELL("col")
Highlight active cell (3rd rule):
For European regional settings (semicolon):
=AND(ROW()=CELL("row");COLUMN()=CELL("col"))
For US/other regional settings (comma):
=AND(ROW()=CELL("row"),COLUMN()=CELL("col"))
⚡ VBA Code
Application.Calculate
⏱ Timestamps
00:00 - Intro
00:10 - Formula for row
00:33 - Formula for column
00:54 - Formula for cell
01:14 - VBA code
01:29 - How to save correctly
🔗 My templates & socials:
🛍 My templates: https://alexaplanners.com/
📷 Instagram: / spreadsheet.mode
🎵 TikTok: / spreadsheetmode
📌 Facebook: https://www.facebook.com/share/17RMCt...