Forum Discussion

Southwood127's avatar
Southwood127
Copper Contributor
May 25, 2020
Solved

Conditional Formulas

I need to conditionally format cells in orange which contain expiration dates older than Today(). If a cell does not contain any date or if it contains a future date from Today(), it should not be fo...
  • karchavez's avatar
    May 26, 2020

    Hi Southwood127 ,

    Please see below the formula and the attached file, this is going to work with empty cells as well.

     
     

    If this formula  fit your expectations, please accept as best response.

     

    Regards,

    Karchavez

Resources