Conditional Formatting problem
 

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

Conditional Formatting problem
 

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

Conditional Formatting problem
 

Of course, each formula starts with an equal sign!

Biff

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

Conditional Formatting problem
 

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