If 3 colors are not possible what about two ?
I can get you 2 colors.

Actually, you can get as many as conditional formatting will allow (which is
3 in versions of Excel prior to Excel 2007).

Just change the MOD divisor to the number of colors you want and change the
comparison accordingly:

For 3 colors:

=MOD(.....,3)=n

Condition 1:
=MOD(.....,3)=0

Condition 2:
=MOD(.....,3)=1

Condition 3:
=MOD(.....,3)=2


--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
If 3 colors are not possible what about two ?

I can get you 2 colors.

Note that these formulas are fairly calculation intensive so this may not
be a good idea if you have 1000's of rows of data.

Based on your sample...

Select the range A1:C11
Goto the menu FormatConditional Formatting
Condition 1
Select the Formula Is option
Enter this formula in the box on the right:
=MOD(ROUND(SUMPRODUCT(($A$1:$A1<"")/COUNTIF($A$1:$A1,$A$1:$A1)),0),2)=0
Click the Format button
Select the desired style(s)
OK

Click the Add button

Condition 2
Select the Formula Is option
Enter this formula in the box on the right:
=MOD(ROUND(SUMPRODUCT(($A$1:$A1<"")/COUNTIF($A$1:$A1,$A$1:$A1)),0),2)=1
Click the Format button
Select the desired style(s)
OK out


--
Biff
Microsoft Excel MVP


"Mr. Low" wrote in message
...
Hello,

I have the following table:

A B C
1 Y12 XXXX XXXX - Yellow
2 Y12
3 T24 - Green
4 T24
5 T24
6 H85 - Pink
7 H85
8 J74 - Yellow
9 M41 - Green
10 M41
11 M41

Is there anyway for me to condition format the table as illustrated? The
block need to change color only when refrence in column A channges. How
should the formula be ? If 3 colors are not possible what about two ?

Thanks

Low




--
A36B58K641