Conditional Formatting problem

J

James A

My 1st and 2nd cond formula's work fine. I can't get the 3rd to work ?

Here's my 1st for (GREEN)
=IF(AND(M6>0,N6="Inc"),TRUE, FALSE))

Here's my 2nd for (YELLOW)
=IF(AND(M6<0,N6="Inc"),TRUE,FALSE))


This formula still returns a YELLOW format?
Here's my 3rd for (RED)
=IF(AND(M6<-0.1,N6="Inc"),TRUE,FALSE))


James A
 
T

T. Valko

You don't need to use the IF function but it'll work as is. Flip the 2nd and
3rd conditions.

Condition 1: (green)

AND(M6>0,N6="Inc")

Condition 2: (red)

AND(M6<-0.1,N6="Inc")

Condition 3 (yellow)

AND(M6<0,N6="Inc")

Biff
 
R

Ragdyer

First of all, you can simplify your formulas and eliminate the IF():

=AND(M6>0,N6="Inc")

Then, just switch condition 2 and 3.

Once the formula evaluates *anything* less then 0, that condition is met
(equates to TRUE). It doesn't look any farther to even see the 3rd
condition.

#1 >>> =AND(M6>0,N6="Inc")
#2 >>> =AND(M6<-0.1,N6="Inc")
#3 >>> =AND(M6<0,N6="Inc")
 
Top