Shading should be based on conditional formatting with formula:
=MOD(ROW();2)=0

HTH
--
AP

"dkingston" a écrit dans le message de
news: ...
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