Format entire column if cell selected in that column?

[MeaclH]

Hi all,

Wondering if there is some sort of VBA code that will allow an entire column to be highlighted, similar to actually selecting the column at the top seen below (entire column goes gray).

For example I select M12, the entire M column will be formatted with a different cell fill colour. This would need to be dynamic, returning to it's original formatting if another cell is selected.
I would like this only to apply to columns G:T.

Appreciate any ideas you may have.


Thanks,
Hayden

 

[MeaclH]

Got it!
Condtional formatting
=COLUMN()=CELL("COL")
worksheet code
Target.Calculate

 

[Skyybot]

Got it!
Condtional formatting
=COLUMN()=CELL("COL")
worksheet code
Target.Calculate

You can always mark your own answer as Solved so that other users can gain from your knowledge.