Home

Formula help please!

dfreeman
New Contributor

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!

3 Replies

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?

 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies