Art,

I am working with version 2003.

Thanks,
John

"JCS" wrote:

Hi Art,

Thanks for the info. I know how to using conditional formatting but not for
highlighting duplicates. Can you give me a suggestion on how to do it?

Thanks,
John

"art" wrote:

Use conditional formatting to find duplicate values. You select conditional
values, and select highlight cell rules to find the duplicates.

"JCS" wrote:

Good Morning All,

I have a spreasdheet with 3 columns. I would like to find the duplicate
entries in all 3 columns. I can find duplicate entries in 2 columns using
the Index and Match functions but don't know haw to find duplicates in 3
columns. Enclosed is a sample of what I would like to do:

Field 1 Field 2 Field 3 Duplicates
smith jones ellis ellis
ellis myers jacobs
daniles ellis gates

Any suggestions would be greatly appreciated. Thanks in advance!
John