Higlighting date on the saved search
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.
Rookie Asked on March 7, 2022 in Saved Searches.