View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
scott scott is offline
external usenet poster
 
Posts: 577
Default Conditional Format Help Needed

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.