Forum Discussion

Jon_Hurtado's avatar
Jon_Hurtado
Copper Contributor
Jul 17, 2020

Formula for Conditional Formatting

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...
Formulas and Functions
Jon_Hurtado's avatar
Jon_Hurtado
Copper Contributor
Jul 17, 2020

SergeiBaklanThank you so much.  Slight modifications and it works.

 

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

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 17, 2020

Jon_Hurtado 

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

Resources