Conditional Format

  • Thread starter Thread starter Maxwell
  • Start date Start date
M

Maxwell

Hi,

I need to write a formula in the conditional formatting
section...

I need the following.. (This is how I would write it in
normal excel but it does not work in conditional format.)

Normal Excel Formula =if(AND(a1<=0,b1<=0),"YES","NO")
Now in conditional format I want the "Yes" to be formatted
as coloring the cell GREEN and if it does not meet
conditiona "NO", then it will leave normal format.

How do I write this in the conditional format formula
screen?


Thanks
 
Select the cell,

format>conditional formatting, formula is

=AND(A1<=0,B1<=0)

click format and select green font
 
Back
Top