is there a way of keeping alternat rows differently coloured

D

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
 
J

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...
 
G

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
 
D

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.
 
Top