Excel Pro Trick: Highlight Active Cell, Active Row and Active Column in Excel Based on Selected Cell

Learn how to highlight active row and active column in Excel data range based on Active cell in Excel.
This method uses Excel conditional formatting with Excel formula to identify and highlight active row and column based on cell selection. And it updates the moment active cell is moved or a new cell is selected!
This is the simplest and easiest method to highlight active cell, active row column in Excel worksheet. With just one line of VBA code, this is not only dynamic, but also keep the original formatting of cells!
Lets Excel!
Excel Workbook to Download or Practice online for this tutorial:
1drv.ms/x/s!Ap...
For more Excel tips, tricks and tutorials don't forget to subscribe to ‪@LearnExceltoexcel‬ channel.
Learn #Excel your way:
===================
Website: learnexceltoex...
--------------------------------------
Pick your favourite social page:
Fb: bit.ly/3yM3dvd
Tiktok: bit.ly/3wFllpf
Tw: bit.ly/3wGCRYU
Pin: bit.ly/3NsjKIU
Yt: bit.ly/3wxKL8a
Insta: bit.ly/3wtT9oW
Music by: / ikson
#exceltutorial #exceltips #excel #excelvba #excelvbatutorial #excelconditionalformatting #office365 #office365free #office

[@rekhahiremath560]

Highly helpful. Thank you!

[@yan5699]

This is actually what i'm looking for hahahaha
Thankssss

[@jewelislam1245]

Very Helpful. Thanks.

[@LearnExceltoexcel]

🥳🥳🥳

[@abhijeetmahajan9]

you are awesome buddy!

[@LearnExceltoexcel]

Appreciate your kind words

[@emilioifill9133]

Love this video, let me ask can the lines be highlighted and zoomed at the same time???

[@dineshselvam2108]

First time it' working after open the file it's working slowly give the solution for this problem

[@ghechol]

Expert 👏

[@LearnExceltoexcel]

That is one rank I will like to avoid just yet :)

[@sufianggoro4161]

Thanks bro.. my reference

[@LearnExceltoexcel]

🥳🥳🥳

[@ImTheFatDad]

Can you make a macro to run this, we have reports that come out daily that would be great to do this at the push of a button

[@LearnExceltoexcel]

Will try to make an add-in of this. That way you will be able to use it on every workbook you open in that Excel where it is installed.

[@ImTheFatDad]

1000 likes!!!

[@yuthoob.handle]

​@@LearnExceltoexcelso have you done it ? I really need it

[@akshaypattekar9151]

after watching your previous video I confused with that process and now I get. thanks...🌟

[@LearnExceltoexcel]

Hey! Hope you are having a good one!
Happy to see that you are keenly following the videos :)
The process in previous videos was based on drop down selection and is even simpler than this one.
Have put that topic in the queue to make a video... So hopefully sooner. But to be honest it's quite simple!

[@akshaypattekar9151]

​@@LearnExceltoexcel ok
in "''2D or Two way Vlookup in Excel"" video how automatically shows

[@Bhavik_Khatri]

Can you please share the macro file?

[@rotslancer2717]

It'd help to include explanation rather than music. Good content though.

[@alializadeh8195]

Thanx

[@optionvidya]

Will undo "i.e control z" work here...

[@deepanchakravarthy1116]

Super ✨✨

[@LearnExceltoexcel]

🤩🤩🤩

[@foysalahmed5672]

Thanks for superb video.
I'm using 365, highlighting is not promptly interacted, I've to refresh the worksheet. Is there any solution?

[@LearnExceltoexcel]

Have you implemented the code as shown?

[@LearnExceltoexcel]

Make sure you're applying it in the same worksheet

[@foysalahmed5672]

@@LearnExceltoexcel I did, as same as you did.....I'll send you a file tomorrow.......

[@salomedumbadze9997]

Second rule disappears from rules, works only once. Can you help?

[@wormy_coder]

🔥🔥

[@LearnExceltoexcel]

😇😇🥳

[@alanfilipiak5001]

How do that on google sheets?

[@jugnu5436]

Can we get this file sheet

[@ckatkit5775]

Does it work on google sheet?

[@LearnExceltoexcel]

Google Sheets has a different coding language. I think its java script if I am not wrong. So this set of codes won't work as is. But Knowing the concepts and that language we can definitely do it in GS.

[@verawalking]

Wooooow

[@LearnExceltoexcel]

🤩🤩🤩

[@Ryouko1224]

Hi. I have problem sending the file. When I send it the code is disabled. Do you have idea why?

[@LearnExceltoexcel]

Save the file as macro-enabled file

[@dianemaeperez7273]

im stuck after Alt+F11, don't see a page where I double click the sheet. what am I supposed to do?

[@salomedumbadze9997]

Go to developer-> view code -> from drop down choose worksheet

[@ytpadyt]

Unfortunately the file can not be xlsx

[@LearnExceltoexcel]

As we are writing a code so it needs to be macro enabled workbook. It will be saved as xlsm.

[@ytpadyt]

@@LearnExceltoexcel Thanx. Its a pity that the script can not be saved in personal.xlsb (separate modul) in order to auto run in xlsx

[@jugnu5436]

Its not working on single click in a cell

[@ThisAditya110]

Doesnt workshet

[@LearnExceltoexcel]

What is not working or you are asking about practice file 🤔

[@zhuzhu9599]

I just hate Macros

[@LearnExceltoexcel]

Well this is an innocent one! Give it some love 😊

[@zhuzhu9599]

@@LearnExceltoexcel sir, give some tips on how to improve in excel.