Say the top left item is in cell A1
then select cell A1
From the menu bar, Format/Conditional Formatting
set condition 1 from "Cell Value is" to "Formula Is" using the dropdown
arrow, and enter the formula
COUNTIF("$A1:$F1,A1)1
and choose format blue background

Finally copy cell A1 to the clipboard and PasteSpecial formats only to the
other cells.

"Francesco" wrote in message
...
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