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