2

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 Jun 27 '19 at 0:32
  • Only 1 cell should change colors (R3) – sproutbrandon Jun 27 '19 at 0:34
0

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

|improve this answer|||||
  • Still not working... I have a screenshot, but I don't see anywhere to attach to this post. I tried Automatic and Number formatting – sproutbrandon Jun 27 '19 at 15:43
  • can you share a copy of your sheet? – user0 Jun 27 '19 at 15:44
  • I posted a SS in OP. And yeah, where to share? – sproutbrandon Jun 27 '19 at 15:46
  • paste the url link here in comments – user0 Jun 27 '19 at 15:47
  • @sproutbrandon answer updated – user0 Jun 27 '19 at 16:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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