Forum Discussion
Solved
Highlight row and column when cell is selected
Hi, Just need a little help to try out coding a sheet where the selected row and column automatically highlights. I could perhaps do it using conditional formatting but I would like to try it...
There is no code whatsoever in that workbook. Perhaps you copied the code to a module in another workbook?
Here is the workbook with the code. You may have to unblock the file after downloading it.
"Warning: This will remove all existing fill color from the entire sheet before highlighting the row and column of the active cell!"
I have fill color on the sheet which I do not want to loose using conditional formatting.
I have fill color on the sheet which I do not want to loose using conditional formatting.