highlighting same numbers?

[jackrobyn1]

I have a range A2:A125, that numbers are entered into, how do i set the
conditional formatting for all these cells so that if any of the numbers are
the same (if they are duplicated in any of these cells) they highlight in a
different colour. red for instance. is there a formula i can enter?
Thanks

 

[Bob Phillips]

=COUNTIF(A:A,A1)>1

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)