macro to compare columns and highlight common rows

I don't think this is a very hard macro to write but i haven't used VB very much and just now learning again. Bascially I need to write a macro that compares account numbers in columns from two different worksheets. If an account number is in both columns I would like to highlight the whole row on both worksheets. I am thinking after it is done it shouldn't be hard to sort by highlighted rows if I am correct. I basically need to find out which accounts are on both worksheets and which ones aren't if someone knows of a simpler way to do this.

Thanks!

please post dummy workbook, 5 rows of data will be enough on each sheet (sensitive data can be changed for anything else)

Which column....whats the worksheet names. A copy of your workbook or test workbook would help a lot.

Thank you MarvinP! That worked perfectly and was very simple.