Chip Pearson has a bunch of web pages devoted to dealing with duplicates.

Check out this link:

http://www.cpearson.com/excel/duplic...tingDuplicates
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Luke" wrote in message
...
Appologies, I had this once and now I can't remember how I did it. did a
search but can't find the conditional format I need.

Have 2 different arrays and some of the numbers are equal in one to the
other. I need to highlight only the cells that are equal in just one of the
arrays
Thanks for your help again
Luke