Conditional Formatting "or" and "but"?

ohhaykfrankk

New member
Joined
Jan 29, 2017
Messages
33
Reaction score
0
Points
0
Excel Version(s)
2010
Here are my formulas:

This one turns green::
=AND($U$31="OPEN",$C$14>1,$C$11>1,$R$24>0)
Done.

This one turns red::
=OR($U$31="xx",$C$11<1,$C$14<1)

BUT I need it NOT to turn red (no color) if $R$24 is 0.

I have another formula but the red one overrides it.
So is there a way I can do an Or format with a But?
 
ha yeah, i didn't realize I could do that.. thank you!!
 
Back
Top