shading alternate rows, but losing format when one row is dele
THANK YOU!!!!
"Gord Dibben" wrote:
Candice
Select all rows.
FormatConditional FormattingFormula is: =MOD(ROW(),2)=1
Pick a pattern from Format and OK your way out.
Gord Dibben MS Excel MVP
On Sat, 22 Apr 2006 16:07:01 -0700, Candice
wrote:
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
|