color lines in a spreadsheet

[BWR]

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

 

[JLGWhiz]

Do the sort first. then add the formatting last.

 

[Gord Dibben]

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

 

[FSt1]

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