Excel function help
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
|