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

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" <dkingston@discussions.microsoft.com> wrote in
message
news:D067317B-C06F-4A87-855E-E48EE5CF961B@microsoft.com...
>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

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

HTH
--
AP

"dkingston" <dkingston@discussions.microsoft.com> a écrit dans le message de
news: D067317B-C06F-4A87-855E-E48EE5CF961B@microsoft.com...
>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

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