Alternate shading of rows

[Dale Hymel]

I used conditional formatting on a range of data to shade alternate rows.
The formula is: =mod(row(),2)=0 then format the pattern for light gray.

How can I keep the alternate rows shaded during auto filtering or the hiding
of certain rows?

 

[Max]

Try MVP Debra D's reply to a similar query
: http://tinyurl.com/2d25a

 

[Bob Phillips]

A slight suggestion to Debra's solution if you have some extra rows
formatted at the end. In some circumstances, they can show up as a shaded
block, so I use this modified CF formula for that

=AND($A1<>"",MOD($A1,2)=0,$B1<>"")

This gives an odd result if B in a inclusive row is blank, but Debra does
warn against this.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)