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