Jul 17 2020 12:07 PM
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
Jul 17 2020 12:28 PM
Jul 17 2020 12:35 PM
Jul 17 2020 01:42 PM
Sorry, my guess was you formatted blank/zero cells to show the dash.