Highlighter
 

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)??

Highlighter
 

Use conditional formatting (Format menu) with a formula of

=COUNTIF($A:$A,A1)1

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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)??

Highlighter
 

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)??