Identifying duplicate data between two worksheets

[mmccra2858]

I'm looking for a way to identify duplicates between Archive B:B and Archive 2 B:B
And highlight the duplications so I can manually edit them.
Is there a formula that I can use, or can I use conditional format between two sheets.

Please see example attached.

Thanks

[tim201110]

smth like that

[mmccra2858]

Thanks, what I'm actually looking for is highlighting duplicates like conditional formating but between two worksheets.

[FDibbins]

Im on 2007, but I know that 2010 allows CF to work directly across sheets. However, I do not know if it will left you use "find duplicates" across sheets. If not, I can think of 2 other options...

1. use this in CF on sheet1 comparing to all of sheet 2
=MATCH(B5,'Archive 2'!$B$1:$B$1178,0)
swap the references round for sheet 2 to sheet 1

2. Alternatively, ise that same formula ina helper column (on each sheet), and then reference that column for teh CF