How can I shade every other row with some rows hidden (autofilter

[Guest]

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.

 

[Jim Cone]

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" <[email protected]>
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.