highlight row nd column on selection

[devendra1]

how can I highlight row and column on click and after click other cell previous selection returns to its previous state.
. I don't want to clear pre colored cells. let's say I have some range filled with red color. i would like to highlight any cells with click. whenever I click any other cell last activated/ selected cell returns to its previous state. and don't remove pre colored cells

 

[Fluff]

Duplicate to: highlight row and column

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.