I want to fill my Excel address book with a light gray color every fifth row
and keep spacing after I add/delete entries. Is this possible? TIA

Select all the cells, use Format/Conditional Formatting, change "Cell Value
Is" to "Formula Is", enter:
=MOD(ROW(),5)=0
Click the format button, select the light gray you want, click OK all the
way out.
Bob Umlas
Excel MVP


"Earl" wrote in message
...
I want to fill my Excel address book with a light gray color every fifth
row
and keep spacing after I add/delete entries. Is this possible? TIA

This works fine but is there a way to take the heading out of the spacing. I
tried deleting/adding but it seems to go to top no matter where I select. TIA

"Bob Umlas" wrote:

Select all the cells, use Format/Conditional Formatting, change "Cell Value
Is" to "Formula Is", enter:
=MOD(ROW(),5)=0
Click the format button, select the light gray you want, click OK all the
way out.
Bob Umlas
Excel MVP


"Earl" wrote in message
...
I want to fill my Excel address book with a light gray color every fifth
row
and keep spacing after I add/delete entries. Is this possible? TIA

Earl

=MOD(ROW(),5)=2

Note: if you insert rows above row 2 you will get no banding in those rows.


Gord Dibben MS Excel MVP

On Mon, 8 Jan 2007 07:29:00 -0800, Earl wrote:

This works fine but is there a way to take the heading out of the spacing. I
tried deleting/adding but it seems to go to top no matter where I select. TIA

"Bob Umlas" wrote:

Select all the cells, use Format/Conditional Formatting, change "Cell Value
Is" to "Formula Is", enter:
=MOD(ROW(),5)=0
Click the format button, select the light gray you want, click OK all the
way out.
Bob Umlas
Excel MVP


"Earl" wrote in message
...
I want to fill my Excel address book with a light gray color every fifth
row
and keep spacing after I add/delete entries. Is this possible? TIA