Higlighting date on the saved search
Hi Everyone,
Can someone help me with the highlighting formula that I can use on the saved search for the below?
so we have 2 column, item received date and Aimed go-live date and we need to highlights anything that has moved in date and could we colour code it in the following way?
GREEN – arriving early
AMBER – moved back by a week but still meeting the GO LIVE DATE (allow 14 days from ship date to go live date)
RED- late and not going to meet the go live date.
Thanks,
Uchi
