Conditional Format Formula for finding duplicates in a row

[Gryf]

I have a huge sheets of text strings that I need to find duplicates whe
they are in a single row. I *can* have duplicates in the sheet, bu
cannot have the duplicates reside in a row.

How would I write the formula to identify duplicates in a row?

Example:

Code
-------------------

A B C D E F
1 Jane Jim John Link Trey Mike
2 John Jim Link Trey Mike Jane
3 Jim John Trey Mike Link Jane
4 John Jim Mike Link Trey Jane
5 Mike John Trey Jim Jane Link
6 John Jim Mike Trey Link Jane
7 Mike Link John Jim Jim Jim
8 Jane John Mike Link Trey Ji
-------------------


Row 7 has duplicates (7d, 7e,7f) that should get highlighted but th
other columns and rows should be fine (Unless I goofed). How do I d
that

 

[Ron Rosenfeld]

I have a huge sheets of text strings that I need to find duplicates when
they are in a single row. I *can* have duplicates in the sheet, but
cannot have the duplicates reside in a row.

How would I write the formula to identify duplicates in a row?

Example:

Code:
--------------------

A B C D E F
1 Jane Jim John Link Trey Mike
2 John Jim Link Trey Mike Jane
3 Jim John Trey Mike Link Jane
4 John Jim Mike Link Trey Jane
5 Mike John Trey Jim Jane Link
6 John Jim Mike Trey Link Jane
7 Mike Link John Jim Jim Jim
8 Jane John Mike Link Trey Jim
--------------------


Row 7 has duplicates (7d, 7e,7f) that should get highlighted but the
other columns and rows should be fine (Unless I goofed). How do I do
that?

Select the region to be formatted (e.g. A1:F8), then use this:

=COUNTIF($A1:$F1,A1)>1