L lino Dec 11, 2007 #1 Pls provide a macro code when finds the numbers which are repeated in a range of cell. Rgds lino.
B Bob Phillips Dec 11, 2007 #2 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)
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)
