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" wrote in message
...
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 FormattingNew 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
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?!?!?!