How To and What... code to enter into VisuaBasic Module to highlight active row/column '07

Good Afternoon! I am working on Excel 2007... and I have approximately 2,000+ rows of data. I've been looking around for a way to have the row/column highlighted yellow of the cell I'm currently typing in... and then when I move on to the next highlight those and return the previous cells to the way they were before and highlight the new row/column of the cell selected highlighted yellow. I am not necessarily an excel novice however I've not ever used Visual Basic and am having a hard time getting other codes I've found via my search to run properly. Does anyone have a code I could use? ... and along with that tips/steps on how to get it to run?

SO MANY THANKS IN ADVANCE!!

Hi

Check, if this code meets your requirements:

Please Login or Register  to view this content.

Disclosure: this is not my code, I just found it on an excel forum website, but I don't remember which one and who is the author of this code.

thank you so much! my only remaining question would be ... is there a code that works with cells that are already colored? thus returning them to the original color after I've moved on to the next?

I really appreciate all of the help - thanks so much!