D
djmiller777
I have a list of rooms in a house listed by row. The room labels are
found in column A, and other room attributes are found in columns B, C,
D, & E. (See attached file: example.xls)
To aid in viewing, I can use auto formatting (List 1) to make every
other row have grey fill color.
If I use filtering to view only the rooms having wallpaper, then every
other row is no longer shaded. I end up with adjacent rows that are
shaded.
Is there any way to always have every other row shaded no matter how
the table is filtered?
Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=402726
found in column A, and other room attributes are found in columns B, C,
D, & E. (See attached file: example.xls)
To aid in viewing, I can use auto formatting (List 1) to make every
other row have grey fill color.
If I use filtering to view only the rooms having wallpaper, then every
other row is no longer shaded. I end up with adjacent rows that are
shaded.
Is there any way to always have every other row shaded no matter how
the table is filtered?
Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=402726