After reading Debra's reply I see that I give you a wrong answer.
You say Filter and not Sort

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Ron de Bruin" wrote in message ...
Use this
http://www.cpearson.com/excel/banding.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"guilbj2" wrote in message
...

I've shaded every other line on a spreadsheet to make it easier to read,
but I'm also using filters. When I filter results, the cell shading is
also filtered out, so instead of white line/gray line over and over I
get blocks of colour which defeat the purpose of the shading. Does
anyone know a way around this ?


--
guilbj2
------------------------------------------------------------------------
guilbj2's Profile: http://www.excelforum.com/member.php...fo&userid=6043
View this thread: http://www.excelforum.com/showthread...hreadid=375075