Google Sheets: Conditional Formatting for Expired Dates.

Solved
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

  • Votes
  • Date
  • Descending date
  1. Hello,

    I hope this screenshot will be clear enough



    Best regards
    1. Hello,

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

      Best regards