Forum Discussion

dfreeman's avatar
dfreeman
Copper Contributor
Apr 05, 2019

Formula help please!

I am having the most difficult time creating a formula for an action, I am very hopeful someone here can help. I  want to apply conditional formatting so that: if K2=0 and G2=<04/15/2019, J2 will have green fill and bold type. I cannot wrap my head around why I cannot get this correct. Someone please help! THANK YOU!

Formulas and Functions

3 Replies

  • JWR1138's avatar
    JWR1138
    Iron Contributor
    Apr 05, 2019

    Hi, I think you'll need to put the date in as a number, so:

     

    =AND(G2<43570,K2=0)

     And make sure G2 is formatted as a date. 

    • dfreeman's avatar
      dfreeman
      Copper Contributor
      Apr 05, 2019

      JWR1138 First of all, thank you for replying! Unfortunately, when I use the formula as suggested, it still is not working correctly. I just don't understand why I am having such a difficult time with this. . .

      • JWR1138's avatar
        JWR1138
        Iron Contributor
        Apr 05, 2019

        Attached is a sample where this should be working, is your data private or can you post a sample of your workbook?