go to format/conditional formatting.

chose formula a put this:
'I am supposing your looked column is A:A
=Countif(($A:$A);A1)1
then put a red format and "DONE

--
Message posted from http://www.ExcelForum.com