Highlight Active Row & Column in Excel (7 Levels)

How to automatically highlight the row and/or column of the active cell so you always know where you are in Excel.

*Watch more videos*

*Click here for the article with full VBA code:*

*Download the Free Excel Workbook*

*TIP: Stay logged in for quick access to all FREE workbook downloads.*

*Chapters:*
00:00 - Intro to Excel Highlighting
00:47 - Manual Highlighting of Rows and Columns
01:17 - Level 1: Highlight Active Row with Conditional Formatting
02:41 - Level 2: Automate Row Highlighting with VBA Code
05:20 - Level 3: Highlight Active Column with Conditional Formatting
07:21 - Level 4: Highlight Both Active Row and Column
09:14 - Level 5: Create Crosshairs Effect with Different Colors
13:18 - Level 6: Adding an On/Off Dropdown
16:29 - Level 7: Adding an On/Off Toggle Button
20:51 - Bonus: Keeping Headers in View
22:33 - Conclusion and More Resources

** UPDATE: **

[launchexcel]

🔹 Chapters:
00:00 - Intro to Excel Highlighting
00:47 - Manual Highlighting of Rows and Columns
01:17 - Level 1: Highlight Active Row with Conditional Formatting
02:41 - Level 2: Automate Row Highlighting with VBA Code
05:20 - Level 3: Highlight Active Column with Conditional Formatting
07:21 - Level 4: Highlight Both Active Row and Column
09:14 - Level 5: Create Crosshairs Effect with Different Colors
13:18 - Level 6: Adding an On/Off Dropdown
16:29 - Level 7: Adding an On/Off Toggle Button
20:51 - Bonus: Keeping Headers in View
22:33 - Conclusion and More Resources

If you prefer to read here is the article with full written instructions:

*Download the Free Excel Workbook*

*TIP: Stay logged in for quick access to all FREE workbook downloads.*

[markhuang]

It is such a high quality tutorial. I like you video very much. I think your tutorials are as good as those of Leila's. Hope to see more videos from your channel.

[paramveerssachdeva]

For this same function / calculation, I have seen various videos in various accents. maybe a hundred.

This tutorial is rated no 1 of out 100. Full marks 100 out of 100. have downloaded the workbook will be attempting to do this on my sheets.

Your explanation is step by step, thorough, leaving out no steps so the person who's learning will not miss out on a single thing. Will be buying your course also as this shows how precise you are. Perfection.

hope there is not lag on the end sheet when i finish doing this to my sheets. As there is no lag on the worksheet i have downloaded from your page,

thanks a lot

[RipRoarLB]

I left the conditional formatting in place, one for the row one for the column. I liked this method rather than the combined method, is so I could use a different format for the column and the row. That could be an alternative. This was a great insight - good job and thank you.

[tusharvador]

Extremely helpful. The level wise instruction really helped.👍🏻

[gordonresquer]

Victor, this is the best tutorial on any Excel subject that I have viewed. My team was inquiring to add this functionality to our workbooks! Can’t wait to start on applying this! Mahalo!

[nasimak]

Victor, you are a GENIUS, Thank you for making such a wonderful and informative video on conditional formatting.

[KelvinKeahey]

Awesome video. I love the clarity of the instructions and the building on process. Thank you!!!

[Weamee]

This is exactly what I was looking for, thank you for your simple to follow instructions.

[flaviotinoco]

It was perfect how you went straight to the point and fast without talking too much with very clear instructions.

[AndyLoweUTube]

Nice demo. Shows concepts that can be utilized for other solutions.

[txreal]

Just got your channel in my Crosshair. AND I switched to ON. Thanks!
Btw, I like the yellow post it note; make it easier to follow.

[balkrishnarana]

Thank you for this beautiful presentation. Even the novice is enticed into fine tuning the Excel experience.

[jimflood]

Your video is the best, was trying to highlight rows and columns and your video was the only one that clearly explained it. Thank you very much for your work.

[MarkMartinGentapan]

I appreciate the tutorial very much! Extremely helpful!

[StepDub]

Clear and concise. Appreciate the inclusion of shortcuts. Thank you.

[Wreinie]

Hi, thank you for a very helpful tutorial. I LOVE how you showed different skill levels to up our game <3

[sitotagirma]

Oh Dear, it is great work that makes life easier. I appreciate your presentation.

[gebguk]

Very good explanation, thank you. Have only one remark: - if use switch with “No Format Set” it’s will remove all formats which was before

[elmolewis]

I was hoping to see how to do this with many existing macros in a worksheet. Good explanation and presentation. I have never understood why this simple and most desirable option was never provided by MS in the 20+ years I've been using Excel.