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

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

On Aug 31, 5:22 pm, Gary''s Student
wrote:
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

Dear Gary's Student,

I tried what you stated. It worked for each column. But if the same
number was in column A once and in column B once, it did not show up
as a duplicate by the conditional formatting.

Steve G

It's time to share the formula you used.

Steve G wrote:

On Aug 31, 5:22 pm, Gary''s Student
wrote:
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

Dear Gary's Student,

I tried what you stated. It worked for each column. But if the same
number was in column A once and in column B once, it did not show up
as a duplicate by the conditional formatting.

Steve G

--

Dave Peterson