I found the code below on http://www.xcelfiles.com/Excel02.html. It is so close to what I need to do. Dear Juan Pablo, if you read this post, I would love your help in making a little adjustment to the code you have below.
It highlights active row and column, but it overwrites the already colored cells. I need it to highlight active row and column while it keeps the already highlighted cells in their original color. So, say I have some cells in yellow. When the code highlights the active row and column in (say) purple, I would like to be able to see the the whole row and column in purple while the yellow cells remain in yellow.
So can anyone tell me how to make the code below keep the original cell color of the already highlighted cells while it highlights the rest of the cells in the active row and column? Pleasee help?
Thank you!
Bookmarks