Quote:
Originally Posted by lp78
hi all. I would be so grateful if anyone could help me with the following. Ive searched threads and couldnt find what i need. i have an excel spreadsheet which has start dates ( both old and current) which i need to turn amber if 90 days has past and red if 180 days has past if there is no end date in column L . Many thanks
|
-------------------------------------------------------------------------
Dear LP78, Good Evening.
Could you explain better your necessity?
Colour_______Status
AMBER_______90 to 179 days has past from START DATE until TODAY
RED_________180 or MORE days has past from START DATE until TODAY
????_________if there is no end date in column L
Please, explain your necessity. I believe that I can help you.