I'm trying to color band this list for item numbers (alternate color
bands for each change in item number), but can only find simple color
band formulas such as this on the web
http://www.cpearson.com/excel/banding.htm Any idea how to do this with
conditional formatting? Thanks for the help

Item Info
1 a
1 b
1 c
1 d
2 e
2 f
2 g
2 h
3 I
3 j
3 k
3 l
3 m

FOUND IT!! for thos looking for the same it's here...

http://groups.google.ca/group/micros...8224784462fa9c
wrote:
I'm trying to color band this list for item numbers (alternate color
bands for each change in item number), but can only find simple color
band formulas such as this on the web
http://www.cpearson.com/excel/banding.htm Any idea how to do this with
conditional formatting? Thanks for the help

Item Info
1 a
1 b
1 c
1 d
2 e
2 f
2 g
2 h
3 I
3 j
3 k
3 l
3 m