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...
Formulas and Functions
  • karchavez's avatar
    karchavez
    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

Abiola1's avatar
Abiola1
MVP
May 26, 2020

Hello Southwood127 

 

Kindly see the screenshots and in the solution attached file. 

 

You can click on Manager Rules to see the formula. 

 

If this answers your question, do accept as Best Response.

 

Regards

 

  • Southwood127's avatar
    Southwood127
    Copper Contributor
    May 26, 2020

    Abiola1 

    Thank you for taking the time to try to help me. However; your effort did not handle empty cells.

Resources