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

Excel function help
 

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

Excel function help
 

Oops, formular should start with "="

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

Excel function help
 

On Fri, 3 Sep 2004 10:10:25 +0100, "Jack Schitt"
wrote:

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.

Thanks, but something is wrong.

I want that every record in the row confronts the other records, non
only with A1.

I hope will be clear...

:: Francesco

Excel function help
 

"Francesco" wrote in message
...

On Fri, 3 Sep 2004 10:10:25 +0100, "Jack Schitt"
wrote:

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.

Thanks, but something is wrong.

I want that every record in the row confronts the other records, non
only with A1.

I hope will be clear...

:: Francesco


It should still work, I think. If you enter "A1" without preceding dollar
signs (ie A1 not $A$1) then when you copy the format to other cells the
reference to A1 should change also to the reference of the destination
cells.

Excel function help
 

I did notice a typo in the original formula;

Should be
=COUNTIF($A1:$F1,A1)1
not
COUNTIF("$A1:$F1,A1)1

You may have already noticed that.