don't move formats on sort

[Guest]

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

 

[Guest]

thanks much guys, the conditional formatting worked like a charm.