software

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 gt; autoformat gt;
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

Candice

Select all rows.

Formatgt;Conditional Formattinggt;Formula 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 gt;
wrote:

gt;I have my sheet rows shaded alternately gray/white, but when I delete a row,
gt;the shading does not update, I have to re-format manually....
gt;I wrote a macro: select all gt; autoformat gt;
gt;and that works, but I am wondering if there is a setting that will just
gt;auto adjust the row shading after I delete or ad a row without having
gt;to run the macro or re-auto format?
gt;Any suggestions will be greatly appreciated.
gt;Thanks, CandiceYou can use quot;Conditional Formattingquot;, which will self-adjust after rows are
inserted or deleted.

Select the range (or all),
Then
lt;Formatgt; lt;Conditional Formatgt;
Select quot;Formula Isquot; in the first box drop-down,
Enter this formula in the next box:

=MOD(ROW(),2)=0

Click quot;Formatquot; and choose a 'Pattern' color to your liking (Gray),
Then lt;OKgt; lt;OKgt;

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 !
---------------------------------------------------------------------------

quot;Candicequot; gt; wrote in message
...
gt; I have my sheet rows shaded alternately gray/white, but when I delete a
row,
gt; the shading does not update, I have to re-format manually....
gt; I wrote a macro: select all gt; autoformat gt;
gt; and that works, but I am wondering if there is a setting that will just
gt; auto adjust the row shading after I delete or ad a row without having
gt; to run the macro or re-auto format?
gt; Any suggestions will be greatly appreciated.
gt; Thanks, CandiceSee 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.comquot;Candicequot; gt; wrote in message
...
gt;I have my sheet rows shaded alternately gray/white, but when I
gt;delete a row,
gt; the shading does not update, I have to re-format manually....
gt; I wrote a macro: select all gt; autoformat gt;
gt; and that works, but I am wondering if there is a setting that
gt; will just
gt; auto adjust the row shading after I delete or ad a row without
gt; having
gt; to run the macro or re-auto format?
gt; Any suggestions will be greatly appreciated.
gt; Thanks, Candice
THANK YOU!!!!

quot;Gord Dibbenquot; wrote:

gt; Candice
gt;
gt; Select all rows.
gt;
gt; Formatgt;Conditional Formattinggt;Formula is: =MOD(ROW(),2)=1
gt;
gt; Pick a pattern from Format and OK your way out.
gt;
gt;
gt; Gord Dibben MS Excel MVP
gt;
gt; On Sat, 22 Apr 2006 16:07:01 -0700, Candice gt;
gt; wrote:
gt;
gt; gt;I have my sheet rows shaded alternately gray/white, but when I delete a row,
gt; gt;the shading does not update, I have to re-format manually....
gt; gt;I wrote a macro: select all gt; autoformat gt;
gt; gt;and that works, but I am wondering if there is a setting that will just
gt; gt;auto adjust the row shading after I delete or ad a row without having
gt; gt;to run the macro or re-auto format?
gt; gt;Any suggestions will be greatly appreciated.
gt; gt;Thanks, Candice
gt;
gt;

THANK YOU TO ALL.
You guys are really terrific!

quot;Candicequot; wrote:

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

I am trying to do the same thing but when I enter either:

=MOD(ROW(),2)=0 or =MOD(ROW()-Rw,N*2) 1gt;N

Into the conditional formatting box, nothing happens. I can go back
into conditional formatting and it will say Formula is =MOD(ROW(),2)=0
or =MOD(ROW()-Rw,N*2) 1gt;N with my settings.

Help!Are you selecting a *range* BEFORE you click into quot;Conditional Formattingquot;?

Are you choosing a *pattern* color AFTER you enter your formula?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
gt; wrote in message oups.com...
gt; I am trying to do the same thing but when I enter either:
gt;
gt; =MOD(ROW(),2)=0 or =MOD(ROW()-Rw,N*2) 1gt;N
gt;
gt; Into the conditional formatting box, nothing happens. I can go back
gt; into conditional formatting and it will say Formula is =MOD(ROW(),2)=0
gt; or =MOD(ROW()-Rw,N*2) 1gt;N with my settings.
gt;
gt; Help!
gt;I found the problem, I was selecting the wrong area. Thanks!