Hi KitKat,
Seems this question came up several times in last few hours
and DDM answered your question in another newsgroup.
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates
PLEASE post to only ONE newsgroup. The microsoft.public.excel...
newsgroups are basically read and answered by the same people
so posting to multiple newsgroups wastes a lot of people's time,
not only is one answer usually sufficient, but you will probably get
the same answer each time.
