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

=AND(M60,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(M60,N6="Inc")
#2 =AND(M6<-0.1,N6="Inc")
#3 =AND(M6<0,N6="Inc")

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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