You can use "Conditional Formatting", which will self-adjust after rows are
inserted or deleted.

Select the range (or all),
Then
<Format <Conditional Format
Select "Formula Is" in the first box drop-down,
Enter this formula in the next box:

=MOD(ROW(),2)=0

Click "Format" and choose a 'Pattern' color to your liking (Gray),
Then <OK <OK

Now, all *even* rows are colored.

To have *odd* rows colored, change formula to:

=MOD(ROW(),2)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Candice" wrote in message
...
I have my sheet rows shaded alternately gray/white, but when I delete a
row,
the shading does not update, I have to re-format manually....
I wrote a macro: select all autoformat
and that works, but I am wondering if there is a setting that will just
auto adjust the row shading after I delete or ad a row without having
to run the macro or re-auto format?
Any suggestions will be greatly appreciated.
Thanks, Candice