color bands for visible rows only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've been using the information at http://www.cpearson.com/excel/banding.htm
to band rows for a while now. This works great for lists when I am sorting.
I would now like to band a filtered list. But, this method bands by row
numbers, including the rows hidden by the filter criteria.
Is there a method to band only the rows currently visible?

I suppose I could develop something with the Advanced Filter copy to another
location option, but I'm hoping for a more direct approach. Any ideas? Thanks,
 
I have just updated my Excel add-in "Shade Data Rows".
It now provides an option to shade just visible rows.
It shades rows by cell value or by every Nth row.

Those willing to try the new version (release 1.40) and
provide comments/feedback should contact me direct at:
(e-mail address removed)
Remove xxx from the email address.

Jim Cone
San Francisco, USA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for formatting rows and columns minimizing the outcome. 1
color banding in Excel after sorting 1
Color Banding / Conditional Formatting 3
How do I filter using multiple columns in Excel? 1
Problem with alternating table rows 2
Banding groups 5
Excel 2002: Can I have a moving colored band for active row ? 1
Excel 2002; Macro for a light color band at the active row 2

Back
Top