Many sheets highlight every other row (banding) to improve readability. The Table feature offers several predefined formats that include bands, but you end up with a table instead of a plain data set. When you don't want a table, use conditional formatting to create alternating bands.
10 creative uses for Excel's conditional formatting feature
by Susan Harkins | April 11, 2012, 1:36pm PDT | Image 15 of 24
Create alternating bands
Create alternating bands - Image 15 of 24
Related Galleries
About Susan Harkins
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.
