Refer:
http://www.j-walk.com/ss/excel/usertips/tip073.htm

Note: You can change the highlighting of differences to highlighting of
duplicates by changing =0 to <0 in the formula.


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=531738