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
|