| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
color bands for visible rows only
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, -- tj |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows based on specific value | Excel Worksheet Functions | |||
| flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
| Row selections by row # OR by even/odd rows in another spreadsheet | Excel Discussion (Misc queries) | |||
| Adding Rows to Master Sheet | New Users to Excel | |||
| Copying Rows when hiding other rows | Excel Worksheet Functions | |||
Threaded Mode
