General discussion
February 10, 2003 at 05:54 AM
im_chaz

Color Banding in Excel

by im_chaz . Updated 23 years, 6 months ago

I have entries in Excel from A2:B11 that look like this.

Bob 1
Bob 3
Bob 19
Chuck 4
Chuck 5
Trish 4
Tom 6
Tom 6
Dave 40

I would like for each group of names to have their own separate color band. Similar to a Green Bar effect which alternate colors (white and green) but in this case I want it to alternate based on each group of names.

Bob should have 3 rows in one color
Chuck should have 2 rows in another color
Trish should have 1 row in anothercolor
Tom should have 2 rows in another color
Dave should have 1 row in another color

My actual range is quite large. I think their may be a way with conditional formatting but not sure if that will help me due to 3 conditional limitations.
I appreciate any help in advance.

Thanks.

This discussion is locked

All Comments