I wonder if you can assist a dinosaur with this please.
I am trying to input a traffic light system onto a spreadsheet where the green light will change to amber when the date is almost expired ie 14days, and the amber chances to red when it has expired.
any Formula I use the reaffirmation lights all go to green. Can you help?
ie
16/04/20 -require this to be amber
16/0320 - require this to be red
16/05/20 - require this to be green.
thank you so much
Lorraine
I am trying to input a traffic light system onto a spreadsheet where the green light will change to amber when the date is almost expired ie 14days, and the amber chances to red when it has expired.
any Formula I use the reaffirmation lights all go to green. Can you help?
ie
16/04/20 -require this to be amber
16/0320 - require this to be red
16/05/20 - require this to be green.
thank you so much
Lorraine