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

How do I keep cell color formats separate from text during A-Z sor
 

See if this helps:

http://cpearson.com/excel/banding.htm

Biff

"aeromutt" wrote in message
...
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