View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Candice
 
Posts: n/a
Default shading alternate rows, but losing format when one row is deleted

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