Updating the Red,Green,Yellow Status Column based on Dates from End date Column
I'm trying to create a formula that changes my status column to the red, yellow, red symbols.
I want to base it on my end date column.
I looked at some examples on the site, but i couldn't quite get it to work on my sheet. I was trying to set up a formula around the following parameters.
Red= Past End Date
Yellow= Within 90 Days of the End Date
Green= more than 90 days until End Date.
Also, there are some cells with N/A. will that affect some formulas?
Thanks for any help.
Help Article Resources
Check out the Formula Handbook template!