View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
aeromutt
 
Posts: n/a
Default How do I keep cell color formats separate from text during A-Z sor

I designed a sheet and colored filled every other row for aesthetic purposes.
However after several days of data entry, I sorted the worksheet but the
formating went with the text. Now I have a mess. I want to separate cell
formating from cell text. How do I do this because I cannot find this
question in my MS office for dummies