I need help with a formula...

T

TinaHR

I'm trying to do a formula for a conditionning formatting....How do I say
=IF cell a2 OR b2<2 AND c2 OR d2=1, then apply the formatting?
I have =IF(OR(A2<2,B2<2),(OR(C2=1,D2=1)))
But's it's reading all 4 situations and applying the formatting if any 4 of
the criteria is met.
 
G

Greg

You should try =IF(AND((OR(A2<2,B2<2),(OR(C2=1,D2=1)))). didn't check it out
so I may be wrong but it should be similar to this.
 
D

Die_Another_Day

That's because you forgot the AND
=IF(AND(OR(A2<2,B2<2),OR(C2=1,D2=1)))

HTH

Die_Another_Day
 
Top