retain blue bar order when sorting

[baltobernie]

I've created a spreadsheet with alternate row shading, similar to the old
style of fanfold paper.

The first column is "date". When I add historical data to this worksheet,
then sort by date, the row shading transfers with the data, ruining the
alternate row shading.

Can I sort without taking the cell colors along, or is there another
solution?

Bernie

 

[Ken Wright]

Take a look here:-

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

 

[Flamikey]

n