I'm hoping that some one can help with this issue.
When I chose a cell in the range C4:C300 I'd like the equivalent row From A to I to be coloured light grey.
So , for example , if I select cell C35 , then cells A35:I35 would be coloured. The colour would cancel once I click elsewhere.
As a complicating factor , I can't use conditional formatting as I have already used all the options.
Grateful for any advice.
Bookmarks