See www.cpearson.com/excel/banding.htm for information about how
to do this with Conditional Formatting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"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