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