How to Auto Highlight Column / Row or both of Active Cell in Excel (English) - Best Excel Trick

[@ErikSummers]

I have looked all over for something like this.... great creative approach! Thank you!

[@Pedalsandrides]

thanks for this, it came handy in my workplace great help

[@PlayersBar-q8n]

Perfect!! This is exactly what I've been looking for!

[@billb6121]

Great video, just wish this worked for the whole Worksheet instead of just a Sheet.

[@drrahatjafri]

Excellent work. Thanks!

[@pummang5829]

This is great!! Thank you!

[@ndaire1078]

Excellent!! Thank you.

[@elleb.128]

Hi, thanks for making this video .Can I ask why when I click save it always ask for save as?

[@AzharKhan-kd9bf]

Hi could any1 help me as the steps suggested above are not working at my end no row or column gets colored on selection

[@carolrooney3353]

when applying conditional formatting, ensure all cells are selected, before writing formula. then double check that excel hasn't 'corrected' your formula for you...

[@carolrooney3353]

also, ensure you left row 1 empty for data to populate

[@CalYeMusicLuvr]

I'm curious - This is working fine on the sheet 1 tab, but I have 6 other tabs it is not including. Do you have a video to expand on that?

[@hazem3240]

Interesting question, please reply to me if you get an answer for this so that I can be notified. Thanks!

[@basawat73]

You have to apply this on each sheet separately

[@billb6121]

That does not work. Have spent three days.. Only works on Sheet 1 of my Workbook.@@basawat73

[@billb6121]

My mistake. You were correct. Have Workbook that has a sheet for each month. Took awhile, and got it to work. Now just have to understand why workbook locks up.@@basawat73

[@smb1387]

If you highlight a column for example RED- can u select a cell and change it from RED to GREEN. No value would trigger this- the spreadsheet tracks dates only.

[@Dave_perry]

Is there any way through which I can apply it on Mac?

[@uniqued4ve]

Works great. But is it normal that the "ctrl + z" (Undo) stops working properly?

[@carolrooney3353]

yes, macro's cannot be undo

[@needizone4952]

Great

[@gustavocortico1681]

This should be a core functionality of excel.

[@MicrosoftOfficeTutorials]

Yea, agree

[@alializadeh8195]

Thanks

[@tazguy371]

This only works if your workbook allows macro code, and you’re not stepping on other events that are already coded.

[@warehousemanagercwcnizamabad]

undo option will be lost.

[@smiljanicn]

this should be a fkn option in M$ Excel

[@carolrooney3353]

to remove color from selected cell to make it even more visible.... =AND(ROW()=$A$1,COLUMN()=$B$1) - formatted to no color

[@billb6121]

Tried it, but still have color on selected cell. Added it as a New Rule, but no change.

[@ferdielopez1]

Thanks