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