highlighting duplicates

[alex]

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?

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[alex]

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