I'm sure Debra appreciates the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Luke" wrote in message
...
Thanks for your effort but I found a better example he
http://www.contextures.com/xlCondFor...html#Duplicate
it is more clear than Chip's page.
Luke

"RagDyeR" wrote:

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