On Nov 8, 9:57*am, "T. Valko" wrote:

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

this did not work for me. THe first condition is always true. I can
see that the help cell would work, but that seems particularly ugly to
me. If only the color of a cell (fore, back, etc) was available via
a simple function. I guess I'll stick with just setting the first
cell of a new set of values to a different color, which is easy.