Say the data is in A1 thru B10. Select the cells and pull-down:

Format Conditional formatting Formula Is

=COUNTIF($A$1:$B$10,A1)1 and pick a nice distinctive background

All the duplicates will be hi-lighted

--
Gary''s Student - gsnu200741


"Raj" wrote:

Hi,
I have a set of numbers through out the sheet.
May be the number is repeated 4 times in the worksheet.

Is there any method without find and replace.
To locate those values.

Thanks in advance!!!
Rajendra