Art,

Yeah, I found this article and tried it before posting. It works great on 1
column but not on 3 unless I am missing something. At any rate, thanks for
the help.

John

"art" wrote:

OK. Not a problem. Read this page, it explains step by step how to apply that.

http://office.microsoft.com/en-us/ex...366161033.aspx

If you just want a quick fix, try the match function, where it would tell
you if there are any matches to the lookup value.

Let me know if this helps, by hitting this post was helpful, or not.

Good luck.

"JCS" wrote:

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