Formatting Worksheet Rows

[smoe]

Is it possible to format every other row to be shaded -
then when adding a row in the middle of the document it
would reset the all rows following to reset to every other
row being white and every other row shaded

 

[Jay]

Is it possible to format every other row to be shaded -

then when adding a row in the middle of the document it
would reset the all rows following to reset to every other
row being white and every other row shaded

If I understand the requirement correctly, one way would be to use
Format >> Conditional formatting
with the formula condition
=MOD(ROW(),2)=0

Excel's built-in "help" describes the basics of conditional formatting.

 

[Frank Kabel]

Hi
see:
http://www.cpearson.com/excel/banding.htm