I have prospecting worksheets that I work on for 1 month at a time and color code as I make contact. Each month, I have to pull new reports and export to excel. I use macros to clean up and format the worksheets, so the columns & column headings always stay the same.

What I need is a way to compare the customer ID of the old sheet to customer ID of the new sheet, and transfer the color coding for each row. Most of the time, the whole row is colored the same, but somethings, individual cells are highlighted with a different color from the rest of the row.

I've looked at commercial solutions to compare worksheets and highlight diffferences in various colors, but these won't work.

Any ideas?