Formula for Conditional Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-1529864%22%20slang%3D%22en-US%22%3EFormula%20for%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529864%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20refer%20to%20the%20screenshot%20below.%26nbsp%3B%20Specifically%20Row%207%20and%20columns%20s%20and%20T.%3C%2FP%3E%3CP%3EI%20am%20looking%20for%20a%20formula%20for%20conditional%20formatting%20that%20can%20be%20used%20when%20there%20is%20no%20value%20in%20S%20or%20T%20and%20the%20date%20in%20N%20has%20already%20passed.%20%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20you%20can%20see%20in%20the%20screenshot%2C%20N7%20has%20a%20date%20of%207%2F11.%26nbsp%3B%20S7%20and%20T7%20do%20not%20have%20values%2C%20so%20those%20are%20overdue.%26nbsp%3B%20What%20formula%20can%20I%20use%20that%20can%20quickly%20identify%20a%20date%20that%20has%20passed%20and%20there%20are%20no%20values%20in%20the%20accompanying%20cells%3F%3C%2FP%3E%3CP%3EExcel%202013%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222020-07-17_11-59-41.jpg%22%20style%3D%22width%3A%20891px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F206110iDA7FF50F7B649762%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%222020-07-17_11-59-41.jpg%22%20alt%3D%222020-07-17_11-59-41.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1529864%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1529934%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20for%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529934%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F595296%22%20target%3D%22_blank%22%3E%40Jon_Hurtado%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3D(N7%26gt%3BTODAY())*(S7%3D%22%22)*(T7%3D%22%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1529949%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20for%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529949%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3EThank%20you%20so%20much.%26nbsp%3B%20Slight%20modifications%20and%20it%20works.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3D(N2%3CTODAY%3E%3C%2FTODAY%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1530093%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20for%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1530093%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F595296%22%20target%3D%22_blank%22%3E%40Jon_Hurtado%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESorry%2C%20my%20guess%20was%20you%20formatted%20blank%2Fzero%20cells%20to%20show%20the%20dash.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Please refer to the screenshot below.  Specifically Row 7 and columns s and T.

I am looking for a formula for conditional formatting that can be used when there is no value in S or T and the date in N has already passed.  

As you can see in the screenshot, N7 has a date of 7/11.  S7 and T7 do not have values, so those are overdue.  What formula can I use that can quickly identify a date that has passed and there are no values in the accompanying cells?

Excel 2013 

 

2020-07-17_11-59-41.jpg

3 Replies

@Jon_Hurtado 

Perhaps

=(N7>TODAY())*(S7="")*(T7="")

@Sergei BaklanThank you so much.  Slight modifications and it works.

 

=(N2<TODAY())*(S2="-")*(T2="-")

@Jon_Hurtado 

Sorry, my guess was you formatted blank/zero cells to show the dash.