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.
Rookie Asked on March 7, 2022 in Saved Searches.
Add Comment
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor