IF AND not working in Google Sheets for Conditional Formatting I 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?

• is this for whole column or just for 1 cell? Jun 27 '19 at 0:32
• Only 1 cell should change colors (R3) Jun 27 '19 at 0:34

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) Also make sure your formatting of R3 cell is Automatic or Number 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) • Still not working... I have a screenshot, but I don't see anywhere to attach to this post. I tried Automatic and Number formatting Jun 27 '19 at 15:43
• can you share a copy of your sheet? Jun 27 '19 at 15:44
• I posted a SS in OP. And yeah, where to share? Jun 27 '19 at 15:46
• paste the url link here in comments Jun 27 '19 at 15:47
• @sproutbrandon answer updated Jun 27 '19 at 16:05