=IF(IF($G2="Ready to Publish",1,0)=1,1,0)

For CF purposes, that can be written as:

=$G2="Ready to Publish"

To combine into a single condition, maybe this...

=AND($G2="Ready to Publish",MOD(ROW()-1,2)=0)

--
Biff
Microsoft Excel MVP


"Scott" wrote in message
...
I would like to apply a Conditional Format based on two factors. Currently
I
have two different Conditions set up.

Condition 1:
=IF(IF($G2="Ready to Publish",1,0)=1,1,0)
This format successfully works to gray out and cross out text that matches
"Ready to Publish."

Condition 2:
=MOD(ROW()-1,2)=0
This format applies alternating row fills for easier viewing.

While both of these formulas work, my problem is Condition 1 overrides
Condition 2 when "Ready to Publish" is detected. Is there a way to
combine
the two formulas so they wouldn't override one another?

Thanks.