Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I shade every other row with some rows hidden (autofilter
How can I shade every other row of an excel spredsheet. Some of the rows are
hidden with the auto filter on. My results always end up with the even rows gray and the odd rows clear. With the autofilter on, some times the odd rows are adjacent, and sometimes the even rows are adjacent. This results in a random coloring of the rows. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I shade every other row with some rows hidden (autofilter
The free Shade Data Rows Excel add-in gives you the option of
shading hidden rows or skipping them. It shades by cell value or by every nth row. Comes with a Word.doc install/use file. Download from here... http://www.realezsites.com/bus/primitivesoftware Jim Cone San Francisco, USA "dlindamood" wrote in message ... How can I shade every other row of an excel spredsheet. Some of the rows are hidden with the auto filter on. My results always end up with the even rows gray and the odd rows clear. With the autofilter on, some times the odd rows are adjacent, and sometimes the even rows are adjacent. This results in a random coloring of the rows. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I shade every other row with some rows hidden (autofilter | Excel Programming | |||
shade hidden rows | Excel Discussion (Misc queries) | |||
AutoFilter & Hidden Rows | Excel Programming | |||
Excel VBA - hidden rows / autofilter | Excel Programming | |||
AutoFilter and Hidden Rows | Excel Programming |