Automate RYGGrey

04/17/19 Edited 12/09/19

I need help with a formula to automate my RYGGrey. Here are the rules:

If status = complete, grey

If status is in progress or not started and finish is in the past, red

If status is in progress or not started and finish is today + 5 days (within the next 5 days), yellow

If status is in progress or not started and finish is greater than 5 days out, green

Comments

Sign In or Register to comment.