View original (French)

Google Sheets: Conditional Formatting for Expired Dates.

Solved
ProtodoxFR -  
PapyLuc51 Posted messages 4569 Registration date   Status Member Last intervention   -
Hello,

I'm looking today for the formula to apply conditional formatting that turns a row red if a date is expired.

Basically, it's for a subscription tracking table with expiration dates. The expiration date is in one cell, and I would like a formula that says if the date in the cell "Subscription End" is exceeded by one day, then the row should turn red.

Can someone provide me with the formula?

Thank you in advance.

Configuration: Windows / Chrome 86.0.4240.111

2 answers

  1.
    PapyLuc51 Posted messages 4569 Registration date   Status Member Last intervention   1 511
     
    Hello,

    I hope this screenshot will be clear enough



    Best regards
    7
    1. PapyLuc51 Posted messages 4569 Registration date   Status Member Last intervention   1 511
       
      Hello,

      I am correcting the formula to avoid coloring if the date cell is empty =AND($E1<>"";$E1<TODAY())

      Best regards
      4
      1. michmichletankdexcel > PapyLuc51 Posted messages 4569 Registration date   Status Member Last intervention  
         
        Thank you
        0