highlighting same numbers?
 

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

highlighting same numbers?
 

=COUNTIF(A:A,A1)1

--
HTH

Bob

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

"jackrobyn1" wrote in message
...
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