Formula for Conditional Formatting

Copper 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.