Formula to change Green Status to Red Status when date has expired

cking

Hello,

I am looking for a formula that will automatically change Green Status to Red Status when the date has expired?

Thank you!

Nikhil Chawla

Hello,

You can use the below formula.

=IF([Expiration Date]@row < TODAY(), "Red", "Green")

 

Best Regards,

Nikhil Chawla

Mike Wilday

Just make sure that the status RYG column is locked. Any manual changes of the status column to any color will overwrite the formula. I highly recommend automating every color-way or none at all. The other drawback is if you want people to manually adjust a column in a report, formulas make those cells uneditable in the reports. 

I just wanted you to be sure of the consequences! 

cking

Thank you Mike!

cking

Thank you!

Mike Wilday

You're welcome!