Use conditional formatting with a formula of

=COUNTIF(A:A,A1)1

--
---
HTH

Bob


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



"lino" wrote in message
...
Pls provide a macro code when finds the numbers which are repeated in a
range
of cell.


Rgds
lino.