don't move formats on sort
 

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

don't move formats on sort
 

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

don't move formats on sort
 

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

don't move formats on sort
 

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

"dkingston" wrote:

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