[quote=T. Valko;727214]Is this what you want:

1 = shade
1 = shade
2
3 = shade
3 = shade
3 = sahde
4
4
5 = shade
6
6
7 = shade
7 = shade

If so, assuming your data starts is in the range A2:A20

Select the range A2:A20
Goto the menu formatCondtional Formatting
Select the Formula Is option
Enter this formula in the box on the right:

=MOD(ROUND(SUMPRODUCT((A$2:A2<"")/COUNTIF(A$2:A2,A$2:A2)),0),2)

Click the Format button
Select the desired style(s)
OK out


--
Biff
Microsoft Excel MVP

__________________________________________________ __________________________________________________ _____


This equation works great, however, it only highlights the values from A2:A20.


Does anyone know how the equation could be tweaked to highlight the entire row?


Thanks!