conditional format

[Gary]

I want cell A1 to change to a green font if cell B1>0 and B2<=0 and B3="nw".
All three conditions must be true before A1 turns to a green font. What
would the conditional formula be?

Regards,
Gary

 

[Alan]

=AND(B1>0,B2<=0,B3="nw")
Regards,
Alan.

 

[T. Valko]

Try this:

=AND(ISNUMBER(B1),B1>0,B2<=0,B3="nw")

 

[Gary]

Worked great...

Thanks!

=AND(B1>0,B2<=0,B3="nw")
Regards,
Alan.