I need help with a formula...
 

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.

I need help with a formula...
 

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.
--
Greg



"TinaHR" wrote:

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.

I need help with a formula...
 

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

HTH

Die_Another_Day

"TinaHR" wrote in message
...
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.