highlighting duplicates

A

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

Bob Phillips

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top