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