Excel function help

[Francesco]

Hi 2 all.

I need help for a little problem.

I've 5 row with 6 record, for example:

|-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------|
| Albert White | Luke Black | Mark Red | Lee Yellow | Mark Red | Maurice Pink |
|-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------|
| Giovanni Rossi | Alberto bianchi | Mario Rossi | Carlo gialli | Patrizio Verdi | Maurizio Rosa |
|-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------|
| Albert White | Luke Black | Mark Red | Lee Yellow | Mark Red | Maurice Pink |
|-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------|
| Giovanni Rossi | Alberto bianchi | Mario Rossi | Carlo gialli | Patrizio Verdi | Maurizio Rosa |
|-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------|
| Albert White | Luke Black | Mark Red | Lee Yellow | Mark Red | Maurice Pink |
|-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------|
| Giovanni Rossi | Alberto bianchi | Mario Rossi | Carlo gialli | Patrizio Verdi | Maurizio Rosa |
|-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------|




Now, i want to create a function that compare every record in a row
and find 2 equals.

Then if the first row contain 2 times "Mark Red" like in example, i
want that the 2 equals become writes in BLU with background yellow.

Sorry for my poor english, i hope that U understand my problem and
help me to solve.

Thanks.

Francesco

 

[Jerry W. Lewis]

There is an extensive discussion of this under your post to
microsoft.public.excel.programming. Please do not separately post the
same question to multiple newsgroups.

Jerry

 

[David McRitchie]

Sounds like that's going to be interesting.
http://google.com/[email protected]

 

[David McRitchie]

Wished I reread the question before being so enthusiastic.
He just wanted to know which rows had repeated cell values within same row.
Still it's good question and example of COUNTIF