is there a way of keeping alternat rows differently coloured

[des-sa]

please help,
is there a way that when you insert a row in a range of cells it
automatically keeps alternative rows coloured, say grey and white. currently
my 2003 excel inserts a white row.
thanks

 

[Jim Thomlinson]

Use conditional formatting something like this...

Select the rows where you want the alternating bands of colour.
From the menu select Format -> Conditional Format
change from Cell Is to Formula Is
Add the formula
=mod(row(), 2)
Change the format pattern to light grey.
That should do it...

 

[Gord Dibben]

Select a gaggle of rows then..........

Format>Conditional Formatting>Formula is:

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

Pick a gray from the Format>Patterns


Gord Dibben MS Excel MVP

 

[drthmedarb in LA]

This is a little off-topic, but more basic, so hopefully one of you can help:
Whenever I create borders in Excel 2007, then save and close, the borders
disappear when I reopen the document. Thanks very much.