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