On May 22, 2:35*pm, "T. Valko" wrote:
Are you looking for the *specific* entries:

al...bb...cc...dd...ee

Do they have to be in that *specific* order? Would this be a match?

cc...bb...al...ee...dd

All the values are the same but they're in a different order.

--
Biff
Microsoft Excel MVP

"Ardy" wrote in message

...
On May 22, 12:16 pm, "T. Valko" wrote:





Let's see if I understand what you want....

If *every* cell in the row contains the same value then highlight that
row.
If *every* cell in that row does not contain the same value then do
nothing.

If that's what you want...

Assuming there are no empty/blank cells...

Try:

=COUNTIF($A2:$W2,$A2)=COLUMNS($A2:$W2)

--
Biff
Microsoft Excel MVP

"Ardy" wrote in message

...
Hello All:
Here is my dilemma…..I am using Excel 2007. I have a spreadsheet with
17,3322 row of data that spans to Column W (A2:W173322) excluding the
header. I am trying to do conditional formatting to bring to light
the duplicate values that are identical across the row and highlight
them. The problem is that the built in function is highlighting
duplicates whenever it finds it. I need to somehow only highlight if
the entire row is duplicate and not only portion. A2:W2 is the entire
row which represents a data set. I tried using =COUNTIF ($A$2:$W
$173322,A2)1 but it is not quit working.

Any Ideas…….

Ardy

Yes Partly
If *every* cell in the row contains the same value then highlight that
row

Here is an Example
* * * *A * * * *B * * * * C * * * * * D * * * * E
1 * * *al * * *bb * * * * cc * * * * dd * * * *ee
2 * * zz * * *gg * * * * mm * * * ll * * * * *ff
3 * * al * * * bb * * * * cc * * * * dd * * * *ee
4 * * ll * * * *mm * * * ff * * * * * pp * * * *ll
5 * * al * * * bb * * * * cc * * * * dd * * * *ee

So the rows that should get highlighted are 1, 3 and 5 *becuse the
rows contain the same info.

Ardy- Hide quoted text -

- Show quoted text -

They will be a match, same order, exact duplicate.......

Ardy