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?

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"alex" <[email protected]> wrote in message
news:[email protected]...
> 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?
>

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