Highlight Active Cell & Row in Excel with Click

Optional tip if this was helpful: paypal.me/LouisDeconinck
Using conditional formatting we can highlight the currently active clicked cell and row in Excel.

[@LahsenOualyad]

Just another Awesome excel tutorials channel,with so low subs,shame on you KZbin.Thank you for the simplicity of your explanations 🙏

[@LouisDeconinck]

Thank you for the kind words, my pleasure!

[@paramveerssachdeva]

I think you are amazing Louis. Have subscribed and will be sharing your channel with others as well. I haven't yet tried this function yet on my mac. I use office 365 on my mac. Will be trying this out today. But, thanks for sharing such a great video. Will be watching for more. i always wondered why microsoft hasn't added this to excel as a default function.

[@LouisDeconinck]

Thank you very much! I have not much experience with Office for Mac, so hopefully it'll work as well.

[@2melinc]

Very useful! Thanks Louis!

[@LouisDeconinck]

My pleasure!

[@ASI15236]

Louis, thank you for the full treatment of the functions used. I find this helpful.

[@LouisDeconinck]

Thank you, I always try to be as complete as possible in my explanations.

[@ireyites1]

This was top notch as I have data with multiple columns and lines, so now I am able to confirm the line location with the highlight

[@LouisDeconinck]

That's a very good use case for this functionality indeed!

[@mariacervantes2697]

Without your help, I would never have been able to do it, TY so much, you got a new subscriber😉

[@LouisDeconinck]

Glad I could help!

[@kinjalmishra54]

I have subscribed too, great videos louis, I will look forward to more. 👏

[@LouisDeconinck]

Thanks for the sub!

[@Bienvo0921]

Thank you. Excellent explanation! Easy and concise.

[@LouisDeconinck]

Glad it was helpful!

[@rltidd27]

Excellent! Helps when entering or looking at data. Thanks much!

[@LouisDeconinck]

Yes, that's actually a great use case!

[@ianl1052]

Excel Magic! Nicely done. Many thanks. Subscribed and liked.

[@LouisDeconinck]

Thanks for the sub!

[@tballjotter]

Great tip and excellent presentation

[@LouisDeconinck]

Glad it was helpful!

[@MacMillan44]

Thanks for the tip !

[@LouisDeconinck]

My pleasure 😁

[@davebramfitt]

Hi, followed your tutorial today and found it very easy to follow, this will be very useful. However, I noticed that I'm unable to paste after setting up a spreadsheet to highlight the row, is there a reason for this and a way around it ?

[@LouisDeconinck]

That's indeed possible when using VBA, I think undo might also be impacted. I don't really know a way around this unfortunately.

[@masgitz]

Brilliant. Thanks.

[@LouisDeconinck]

Glad you liked it!

[@aliasghar09]

This is amazing

[@LouisDeconinck]

Thanks!

[@hannahliu7790]

Very helpful video, Louis! Would you share what software you use to record and edit your videos too?

[@LouisDeconinck]

I use Camtasia, it's very user-friendly.

[@xllearner]

Is it possible to put the macro and custom formatting in a personal macro workbook? So it would be available all of the time

[@LouisDeconinck]

That would be very cool indeed, unfortunately I'm not aware of a method that would allow for that.

[@zhuzhu9599]

Should we save this workbook with macro enabled or saving withot macro will it still work when we open it?

[@LouisDeconinck]

You'll have the save with macro's enabled unfortunately.

[@theasiamtmgroup]

I tried to follow this, but the VB doesn't work on a Mac, it seems. I tried a workaround, but the selection highlight doesn't change with the cell change by clicking on it. The VB also won't let me select Workbook. It only lets me stay on General. Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) Application.Calculate End Sub

[@LouisDeconinck]

Unfortunately I don't have a Mac to try and make it work. I would think ChatGPT might be able to help out?

[@mikeleblanc9103]

I’m unable to run the VBA in my workbook that is all Tables? Do you have any suggestions?

[@LouisDeconinck]

I would need some more info. This approach only works with VBA. You could try to change the file extension to .xlsm

[@paramveerssachdeva]

When I select Visual Basic and the proceed to select worksheet from General/worksheet. I get a notification "Variable uses an Automation type not supported in Visual Basic" So I cannot proceed further. please help.

[@LouisDeconinck]

Have you written something in the VBA box? It is important that you start the VBA code with Private Sub Worksheet_SelectionChange(ByVal Target As Range)

[@paramveerssachdeva]

@@LouisDeconinck I have tried this in parallels which is a software which allows windows to be used in a Mac. I used excel in the windows OS and then then the Via works, But the cells light up with a lag, and this is also true with other windows users. The cells highlighting is there but there is a lag time in lighting up.

[@edwindeo]

Would know how to highlight cells diagonally and anti diagonally

[@LouisDeconinck]

Interesting question, I'll have to think about that one, I'm not sure.

[@edwindeo]

@@LouisDeconinck I wanted somethings that would highlight vertically, horizontally, anti diagonally and diagonally from active cell. Enough to fill 50 cells either way

[@veruscrt]

I've subscribed to your channel.

[@LouisDeconinck]

Thanks for subscribing!