Hello, In Excel '07 I want to stagger the color of lines in a spreadsheet -
one grey, then one white. I can do this manually, but when I go to sort the
lines (say change them alphebetically) the color lines change with the
alphabetization. I want the color lines to stay staggered when I sort the
data. I want the staggred colorlines o remain the same and only change the
data.

Staggering the lines maks it easier for employees to read and follow the
correct line.

Please help?!?!?!

Do the sort first. then add the formatting last.



"BWR" <(E-Mail Removed)> wrote in message
news:5315D5D1-CF9A-4B73-AE1D-(E-Mail Removed)...
> Hello, In Excel '07 I want to stagger the color of lines in a
> spreadsheet -
> one grey, then one white. I can do this manually, but when I go to sort
> the
> lines (say change them alphebetically) the color lines change with the
> alphabetization. I want the color lines to stay staggered when I sort the
> data. I want the staggred colorlines o remain the same and only change
> the
> data.
>
> Staggering the lines maks it easier for employees to read and follow the
> correct line.
>
> Please help?!?!?!
>

Select rows 1:200 or whatever you want the range to be.

In Conditional Formatting>New Rule enter this in "use a formula"

=MOD(SUBTOTAL(3,$A1:$A$2),2)=0

Pick a gray color and OK

Will survive through sorting and filtering.


Gord Dibben MS Excel MVP


On Sat, 7 Nov 2009 07:08:06 -0800, BWR <(E-Mail Removed)>
wrote:

>Hello, In Excel '07 I want to stagger the color of lines in a spreadsheet -
>one grey, then one white. I can do this manually, but when I go to sort the
>lines (say change them alphebetically) the color lines change with the
>alphabetization. I want the color lines to stay staggered when I sort the
>data. I want the staggred colorlines o remain the same and only change the
>data.
>
>Staggering the lines maks it easier for employees to read and follow the
>correct line.
>
>Please help?!?!?!
>

hi
perhaps you could use conditional formating instead. see this site.
http://www.cpearson.com/excel/banding.aspx
the above site colors cells but it would be easy to color lines instead of
cells.
chip has another page you might would to look at
http://www.cpearson.com/excel/rowliner.htm

perhaps one of the above will solve your problem.

Regards
FSt1
"BWR" wrote:

> Hello, In Excel '07 I want to stagger the color of lines in a spreadsheet -
> one grey, then one white. I can do this manually, but when I go to sort the
> lines (say change them alphebetically) the color lines change with the
> alphabetization. I want the color lines to stay staggered when I sort the
> data. I want the staggred colorlines o remain the same and only change the
> data.
>
> Staggering the lines maks it easier for employees to read and follow the
> correct line.
>
> Please help?!?!?!
>