View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Proto Proto is offline
external usenet poster
 
Posts: 5
Default How can I hold every other row color on a sheet when I sort

I am trying to run a roll sheet and to help read it I made every other line
light green.
The problem comes when I sort the line color goes with the data entered so I
lose my every other line color. Is there a way around that? I have tried
the format sheet option and come up with the same problem