View Single Post
  #1   Report Post  
g wills
 
Posts: n/a
Default Can you sort text in a column, but leave cell color alone?

1st time using excel....

I want to make a wrestling roster to keep the wrestlers weights for
each day. I would like to have a wrestler's name and weight of each
day in a row. To make it easier to see, I would like for every other
row to have a grey shade (like stripes). When I sort, the shade goes
with the text.

Is there anyway to make a shade on each other row and still be able to
sort?