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

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