Google-sheets – IF AND not working in Google Sheets for Conditional Formatting

conditional formattingformulasgoogle sheets

enter image description hereI am trying to use the three following functions…

=IF(AND(M3="Funding on Hold",R3>=3,R3<=6),TRUE,FALSE)
=IF(AND(M3="Funding on Hold",R3<=9,R3>=7),TRUE,FALSE)
=IF(AND(M3="Funding on Hold",R3>=10),TRUE,FALSE)

The objective is to conditionally format these three functions to a certain color. The first function is supposed to turn YELLOW if the value in R3 is greater than or equal to 3, but less than or equal to 6 (so if the value is 5, the cell color should fill as YELLOW).

The second function will be ORANGE, and the third function to be RED.

I use these above formulas as "Custom Formula is", but it does not work. It works perfectly in Excel.

What am I doing wrong?

Best Answer

Your syntax is correct, so only issue could be locale. Try:

=IF(AND(M3="Funding on Hold";R3>=3;R3<=6);1)
=IF(AND(M3="Funding on Hold";R3<=9;R3>=7);1)
 
=IF(AND(M3="Funding on Hold";R3>=10);1)

0

Also make sure your formatting of R3 cell is Automatic or Number

0

Update:

Your issue is in M3 cell. M3 is Funding on Hold[space] not Funding on Hold, therefore, formula needs to be:

=IF(AND(M3="Funding on Hold ",R3>=3,R3<=6),1)

0

Related Topic