Forum Discussion
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 hav...
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.
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. . .
Attached is a sample where this should be working, is your data private or can you post a sample of your workbook?