You should use Conditional Formatting to shade the cells. See
www.cpearson.com/excel/banding.htm for more details and formulas.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"dkingston" wrote in
message
...
i have a sheet where every other line is shaded. i want to sort
the data but
maintain the every other line shaded format. is there a way to
do this
without writing a macro to redo the formating every time i
sort?
thanks in advance for your time.
dkingston