See Chip Pearson's site for highlighting duplicates using CF.

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


Gord Dibben MS Excel MVP

On Thu, 28 Sep 2006 08:52:01 -0700, JN wrote:

How do you find duplicate text entries using conditional formatting? All
information is geared towards number format.
I have names (all in one col) that I would like to find out if they are
duplicated...