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?
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?