View Single Post
  #1   Report Post  
guilbj2
 
Posts: n/a
Default Preventing a Filter from affecting cell shading


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