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(M60,N6="Inc")

Condition 2: (red)

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

Condition 3 (yellow)

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

Biff

"James A" wrote in message
...
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(M60,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