Try this for a test:

Select B2 to B30, then,

<Format <ConditionalFormat
Change "Cell Value Is" to "Formula Is",
And enter this formula:

=SUMPRODUCT(--(B2:C2=$B$2:$C$30))2

Click on "Format" and choose a loud red font and bright yellow pattern
color, then <OK <OK.

Now, make sure you have some duplicates in B & C.

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Amie G" wrote in message
...
Thanks Nikki.

I've tried your suggestion but I must be doing something wrong because I'm
still not getting anything. I even made a small sample set with fake
duplicates just as a test. It seems like I'm doing exactly what you
suggested, but I've tried so many suggestions now with no success that I
think I must be repeatedly missing some critical step somewhere.

Is someone able to walk me through step by step?

Thanks!


"Nikki" wrote:

I would make a column combining name and last name in column D, =B&C and
then
would use conditional formatting formula is highlight the column go to
format
conditional formatting chnage cell value is to formula is and use this
formula and =COUNTIF($d$1:$d$14,d1)1 click on format and choose a
color.

Nikki

"Amie G" wrote:

I'm trying to locate duplicate records in my spreadsheet. It has 15
columns
and almost 3000 rows. Row B is Last Name and Row C is First Name. I
need to
highlight any records that have the same last and first names. So if
there
are multiple Bob Jones I want to check and see if they are the same
person.

How do I do this? I've tried all kinds of methods suggested on the
web and
have not been able to find a solution. Thanks!