VBA to compare and highlight differences

Hi Everyone! I haven't been able to find what I'm looking for so maybe someone might be able to help. I have to worksheets I get from two different dbases do the output is slightly different in each. What I need is simple, (I think). Just need to get a VBA that looks from Sheet1 to Sheet2 for a doc number. If it's not on Sheet 2, simply highlight it BLUE on Sheet, AND then looks from Sheet2 to Sheet1, and if it's not on Sheet1, then highlight the entry on Sheet2 GREEN.

I.E.

SHEET1 SHEET2
COL A COL A

11111 AAAAA
22222 BBBBB
33333 11111
AAAAA 44444


Thank All!!!

Perhaps a macro like this?

Please Login or Register  to view this content.

Alf

Cross posted:http://www.ozgrid.com/forum/showthread.php?t=181455

Came across this old thread.

Can this code be easily adapted to do the same but rather than just comparing column A to compare A:E?

works perfectly thanks xladept

applied the code to a larger data set and the compare doesn't seem to flag up the differences. Can't quite figure out why...

Are there any limitations with the code which would only flag up a portion of the differences or none at all with the code running through without errors?

If i can't find an answer i'll post up a separate thread

posted up a new post here - http://www.excelforum.com/excel-prog...ting-code.html