software

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
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 mFOUND IT!! for thos looking for the same it's here...

groups.google.ca/group/micros...8224784462fa9cwrote:
gt; I'm trying to color band this list for item numbers (alternate color
gt; bands for each change in item number), but can only find simple color
gt; band formulas such as this on the web
gt; www.cpearson.com/excel/banding.htm Any idea how to do this with
gt; conditional formatting? Thanks for the help
gt;
gt; Item Info
gt; 1 a
gt; 1 b
gt; 1 c
gt; 1 d
gt; 2 e
gt; 2 f
gt; 2 g
gt; 2 h
gt; 3 I
gt; 3 j
gt; 3 k
gt; 3 l
gt; 3 m