Google Sheets: Conditional Formatting for Expired Dates.
Solved
ProtodoxFR
-
PapyLuc51 Posted messages 4565 Registration date Status Membre Last intervention -
PapyLuc51 Posted messages 4565 Registration date Status Membre 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
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
I am correcting the formula to avoid coloring if the date cell is empty =AND($E1<>"";$E1<TODAY())
Best regards