highlighting duplicates
 

I want to write a formula that highlights duplicate cells within a
column.
I know that I can use conditional formatting with a named range using
COUNTIF.
I continually paste data into this column, however, and find using a
named range to be difficult. Any suggestions on using an actual cell
range, e.g., A1:A500?

highlighting duplicates
 

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"alex" wrote in message
oups.com...
I want to write a formula that highlights duplicate cells within a
column.
I know that I can use conditional formatting with a named range using
COUNTIF.
I continually paste data into this column, however, and find using a
named range to be difficult. Any suggestions on using an actual cell
range, e.g., A1:A500?

highlighting duplicates
 

thanks bob. it worked. i thought i tried this formula; i guess not
exactly!