Hi, I came accross a formula that can be used as a condition in
Conditional Formatting for Alternate Row Coloring. The formula is "
=AND(MOD(ROW(),2),COUNTA($A1:$C1)) ". Now this formula works really
nice, however it is only limited to one color condition for example
"Yellow", while the second color remains as the background color
example "White". If I want to add a second color other than "White"
say "Red" what change do I need to make to the above formula so that I
can insert it as a 2nd condition in the Conditional formatting. So
that I can have Yellow and Red alternating

Appreciate any help. Thankyou

Ed

=MOD(ROW(),2) for yellow
=NOT(AND(MOD(ROW(),2)) for red

The second condition COUNTA($A1:$C1) limits the scope of CF to rows in which
one of cells A:C are not blank.

--
Regards!
Stefi



„Nedâ€� ezt Ã*rta:

> Hi, I came accross a formula that can be used as a condition in
> Conditional Formatting for Alternate Row Coloring. The formula is "
> =AND(MOD(ROW(),2),COUNTA($A1:$C1)) ". Now this formula works really
> nice, however it is only limited to one color condition for example
> "Yellow", while the second color remains as the background color
> example "White". If I want to add a second color other than "White"
> say "Red" what change do I need to make to the above formula so that I
> can insert it as a 2nd condition in the Conditional formatting. So
> that I can have Yellow and Red alternating
>
> Appreciate any help. Thankyou
>
> Ed
> .
>

I believe you left out one right bracket and I think that:
=MOD(ROW(),0) will also produce the RED background.
Micky


"Stefi" wrote:

> =MOD(ROW(),2) for yellow
> =NOT(AND(MOD(ROW(),2)) for red
>
> The second condition COUNTA($A1:$C1) limits the scope of CF to rows in which
> one of cells A:C are not blank.
>
> --
> Regards!
> Stefi
>
>
>
> „Nedâ€� ezt Ã*rta:
>
> > Hi, I came accross a formula that can be used as a condition in
> > Conditional Formatting for Alternate Row Coloring. The formula is "
> > =AND(MOD(ROW(),2),COUNTA($A1:$C1)) ". Now this formula works really
> > nice, however it is only limited to one color condition for example
> > "Yellow", while the second color remains as the background color
> > example "White". If I want to add a second color other than "White"
> > say "Red" what change do I need to make to the above formula so that I
> > can insert it as a 2nd condition in the Conditional formatting. So
> > that I can have Yellow and Red alternating
> >
> > Appreciate any help. Thankyou
> >
> > Ed
> > .
> >

Or the same without the AND?
--
David Biddulph

"Stefi" <(E-Mail Removed)> wrote in message
news:2BF4716F-04AB-4BD6-939B-(E-Mail Removed)...
> =MOD(ROW(),2) for yellow
> =NOT(AND(MOD(ROW(),2)) for red
>
> The second condition COUNTA($A1:$C1) limits the scope of CF to rows in
> which
> one of cells A:C are not blank.
>
> --
> Regards!
> Stefi
>
>
>
> "Ned" ezt írta:
>
>> Hi, I came accross a formula that can be used as a condition in
>> Conditional Formatting for Alternate Row Coloring. The formula is "
>> =AND(MOD(ROW(),2),COUNTA($A1:$C1)) ". Now this formula works really
>> nice, however it is only limited to one color condition for example
>> "Yellow", while the second color remains as the background color
>> example "White". If I want to add a second color other than "White"
>> say "Red" what change do I need to make to the above formula so that I
>> can insert it as a 2nd condition in the Conditional formatting. So
>> that I can have Yellow and Red alternating
>>
>> Appreciate any help. Thankyou
>>
>> Ed
>> .
>>

Ignore my CF formula.
Micky


"מיכ�ל (מיקי) �בידן" wrote:

> I believe you left out one right bracket and I think that:
> =MOD(ROW(),0) will also produce the RED background.
> Micky
>
>
> "Stefi" wrote:
>
> > =MOD(ROW(),2) for yellow
> > =NOT(AND(MOD(ROW(),2)) for red
> >
> > The second condition COUNTA($A1:$C1) limits the scope of CF to rows in which
> > one of cells A:C are not blank.
> >
> > --
> > Regards!
> > Stefi
> >
> >
> >
> > „Nedâ€� ezt Ã*rta:
> >
> > > Hi, I came accross a formula that can be used as a condition in
> > > Conditional Formatting for Alternate Row Coloring. The formula is "
> > > =AND(MOD(ROW(),2),COUNTA($A1:$C1)) ". Now this formula works really
> > > nice, however it is only limited to one color condition for example
> > > "Yellow", while the second color remains as the background color
> > > example "White". If I want to add a second color other than "White"
> > > say "Red" what change do I need to make to the above formula so that I
> > > can insert it as a 2nd condition in the Conditional formatting. So
> > > that I can have Yellow and Red alternating
> > >
> > > Appreciate any help. Thankyou
> > >
> > > Ed
> > > .
> > >

Of course, I forgot to delete it, thank you for the warning!

--
Regards!
Stefi



„David Biddulphâ€� ezt Ã*rta:

> Or the same without the AND?
> --
> David Biddulph
>
> "Stefi" <(E-Mail Removed)> wrote in message
> news:2BF4716F-04AB-4BD6-939B-(E-Mail Removed)...
> > =MOD(ROW(),2) for yellow
> > =NOT(AND(MOD(ROW(),2)) for red
> >
> > The second condition COUNTA($A1:$C1) limits the scope of CF to rows in
> > which
> > one of cells A:C are not blank.
> >
> > --
> > Regards!
> > Stefi
> >
> >
> >
> > "Ned" ezt Ã*rta:
> >
> >> Hi, I came accross a formula that can be used as a condition in
> >> Conditional Formatting for Alternate Row Coloring. The formula is "
> >> =AND(MOD(ROW(),2),COUNTA($A1:$C1)) ". Now this formula works really
> >> nice, however it is only limited to one color condition for example
> >> "Yellow", while the second color remains as the background color
> >> example "White". If I want to add a second color other than "White"
> >> say "Red" what change do I need to make to the above formula so that I
> >> can insert it as a 2nd condition in the Conditional formatting. So
> >> that I can have Yellow and Red alternating
> >>
> >> Appreciate any help. Thankyou
> >>
> >> Ed
> >> .
> >>
>
>
> .
>

In your case - you may also consider to format ALL rows in one of the colors
and use only ONE CF coloring for the ODD or EVEN rows.
Micky


"Stefi" wrote:

> Of course, I forgot to delete it, thank you for the warning!
>
> --
> Regards!
> Stefi
>
>
>
> „David Biddulphâ€� ezt Ã*rta:
>
> > Or the same without the AND?
> > --
> > David Biddulph
> >
> > "Stefi" <(E-Mail Removed)> wrote in message
> > news:2BF4716F-04AB-4BD6-939B-(E-Mail Removed)...
> > > =MOD(ROW(),2) for yellow
> > > =NOT(AND(MOD(ROW(),2)) for red
> > >
> > > The second condition COUNTA($A1:$C1) limits the scope of CF to rows in
> > > which
> > > one of cells A:C are not blank.
> > >
> > > --
> > > Regards!
> > > Stefi
> > >
> > >
> > >
> > > "Ned" ezt Ã*rta:
> > >
> > >> Hi, I came accross a formula that can be used as a condition in
> > >> Conditional Formatting for Alternate Row Coloring. The formula is "
> > >> =AND(MOD(ROW(),2),COUNTA($A1:$C1)) ". Now this formula works really
> > >> nice, however it is only limited to one color condition for example
> > >> "Yellow", while the second color remains as the background color
> > >> example "White". If I want to add a second color other than "White"
> > >> say "Red" what change do I need to make to the above formula so that I
> > >> can insert it as a 2nd condition in the Conditional formatting. So
> > >> that I can have Yellow and Red alternating
> > >>
> > >> Appreciate any help. Thankyou
> > >>
> > >> Ed
> > >> .
> > >>
> >
> >
> > .
> >