See Chip Pearson's page on duplicates and uniques:

http://www.cpearson.com/excel/duplicat.htm

You could probably use a macro or conditional formatting, but this page will
give you some of the basics.

--
Regards,
Tom Ogilvy


"Zip Codes" wrote in message
...
is there a function or macro that will highlight a cell if it is a
duplicate
so if i had the word house in column a row 3, and then again in column a
row
455, that it would highlight the cell (or both the cells)??