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?

  • is this for whole column or just for 1 cell?
    – user0
    Commented Jun 27, 2019 at 0:32
  • Only 1 cell should change colors (R3) Commented Jun 27, 2019 at 0:34

1 Answer 1


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



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 Commented Jun 27, 2019 at 15:43
  • can you share a copy of your sheet?
    – user0
    Commented Jun 27, 2019 at 15:44
  • I posted a SS in OP. And yeah, where to share? Commented Jun 27, 2019 at 15:46
  • paste the url link here in comments
    – user0
    Commented Jun 27, 2019 at 15:47
  • @sproutbrandon answer updated
    – user0
    Commented Jun 27, 2019 at 16:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.