Welcome!

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!

Find more posts tagged with

Formulas

Comments

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!

Sign in to join the conversation!

Quick Links

Trending discussions

Formula to find data in table with multiple columns based on 2 critera
I am looking for a formula that will look at this table and pull the hours per week based on 2 criteria – group and week. Right now, I have the tables separated so that I can use a vlookup formula. But that means I have to have 5 different formulas, 1 for each group. =IFERROR(VLOOKUP(ROUND(($[First Receive]@row - $[Week 1…
How would I add in a month based off a date in another column
Hi, I am needing to create a column that will display the correct month based off a date in another column. My columns are below. I am not certain on which formula to use. Thanks for the assistance!
If Formula to return highest priority
My spreadsheet has 4 columns are updated each Month with Stable, Improving, Developing, and Negative. Negative is the highest priortiy, then Developing, then Improving. Please assist with a IF statement, that would look at all 4 columns an update the cell with the highest priority word.example 3 stables and a developing…