Alternate shading of rows

  • Thread starter Thread starter Dale Hymel
  • Start date Start date
D

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?
 
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)
 
Back
Top