View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tony tony is offline
external usenet poster
 
Posts: 313
Default auto-filter in excel but leave cell background color

I want to create a simple chart with alternating row colors to easily read
data. When I auto-filter the data it moves the cell color. I want to keep
nice alternating rows.