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

=AND(MOD(ROW(),2)=0,COUNTA($A1:$C1))
--
David Biddulph

Ned wrote:
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" wrote in message
...
=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" wrote in message
...
=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" wrote in message
...
=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
.



.