Fiil Color Fixed Spacing
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
|