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

shading alternate rows, but losing format when one row is deleted
 

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

shading alternate rows, but losing format when one row is deleted
 

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

shading alternate rows, but losing format when one row is deleted
 

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

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

shading alternate rows, but losing format when one row is deleted
 

THANK YOU TO ALL.
You guys are really terrific!

"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

shading alternate rows, but losing format when one row is deleted
 

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

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

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)+1N with my settings.

Help!

shading alternate rows, but losing format when one row is deleted
 

Are you selecting a *range* BEFORE you click into "Conditional Formatting"?

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
wrote in message
oups.com...
I am trying to do the same thing but when I enter either:

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

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)+1N with my settings.

Help!

shading alternate rows, but losing format when one row is deleted
 

I found the problem, I was selecting the wrong area. Thanks!