Highlight Active Row and Column in Excel (Based on Cell Selection)

It's working but when i close the file and then i have to copy the code again because it's not working. Is it possible to working every time when i open the excel file?

Thank you so much for this tip! It will help me in my day to day work with spreadsheets.

If you change the OR function to the AND function, it will highlight the selected cell only.

Very nice, thank you!!! ❤

Helloo
Good video
But question if there is any other coloured cells, will this work?

Hello good day. Having fun viewing your video presentation in autohighlight data in column and rows. Question? How can I make this with my Mac? Thanks

Thank you for this! Very helpful even 3 years later. Did you ever run into any copy and paste issues? I can't seem to copy and paste now. Thanks!

great! serves my purpose! thanks.... but how can I still edit the sheet? I can't add rows, copy and paste.... thanks

I tried using same, however getting error in cut copy mode line

I have used 'If Application.CutCopyMode = False Then'

Thanx a ton mate. Good luck and best wishes.

best tutorial on this concept yet, and very clean formatting. thanks!

Thank you so much.

Great video, but bad name of the channel. The former us president led a violent insurrection that could had let to many elected congress people have died.

How can I highlight only H1 and A4 when active cell(selected cell) is H4 ?

Not working for all workbook 🙄🙄🙄

Hi thanks for your great video however when I press f9 this just locks my computer and doesnt do as you say in the video. Do I need to press something else before f9?

Thank you so much for this. I have a problem though. When I inserted a row on the spread sheet. The highlight is not working on the inserted row

I'm trying this in 365 and it doesn't seem to work?

So so helpful thank you.

Maine pura process kiya but sheet colse hone k baad open karne par formate kam nahi kar raha h please help

Hi. I followed every step but i cant seem to make this work :( pls help

I have successfully created sheet just like you created but I have a two different locations that I run the same Excel workbook using OneDrive cloud but the one PC doesn’t show the highlighted data… it only shows after I press F9 key.

Excellent Work

why not placing the formula directly in description :) :)

thanks for share it!

If I select more than one cell then it still highlights only one row and one column

Exactly what I was looking for

When I select multiple cell then this fuction is not highlight multiple rows and columns as kutools reading layout fuction works.

Leave it to Microsoft to make a very easy thing, incredibly convoluted and confusing.

The conditional formatting isn't working and I tried too much

Excellent tutorial!!!

Great

That's very helpful. Thank you for sharing this tip.

how to make this on google spreadsheet??

Thank you, this was helpful!

thank you, well done

Thanks man. You are first person that i have subscribed for excell.
Solved my problem. Stay blessed always

I did this and work a day but i shut down system and on next day but formula does not work ....please tell me why it was happening..

If I refresh also no change occurs

Y pressing f9 because in my system if I press my system gets locked

I cannot make it work in macbook. Please help. I am using office 365 latest version.

This is great but now i can't copy or paste. If there is a trick to this, please share.

How do we apply this formula for a file with 100 sheets of similar data in every sheet?

excellent tutorial best for beginners

no new at all, we need something without vba

Excellent video................ ... this video resolved my biggest headache to read excel data...Thank you so much for the video

What if you have a drop down verification in a column? It seems to not work at all.