color lines in a spreadsheet
 

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?!?!?!

color lines in a spreadsheet
 

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?!?!?!

color lines in a spreadsheet
 

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?!?!?!

color lines in a spreadsheet
 

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?!?!?!