New user needing help with formula.
I would like it to be something like this:
When the due date is => than today -1 turn red, if the due date is < today - 3 days turn yellow, if due date is is =. than today +5 turn green
The idea is if a task is due today or tomorrow its red, if a task is due within 3-5 days its yellow and if a task is due in more than 5 days turn green.
Now i know how to use conditional formatting to get my colors. I'm jut not 100% how to set up the formula.
Any knowledge you have will be wonderful. Thank you.