Change color if date has passed? Conditional formatting question

So I have created a todo list app and I would like there to be colored circles showing the urgency of each task…

Currently if the task is due today the circle will turn red.
If it isn’t due for a week it will be green…

Etc.

That being said, if a task is late I would like it to also be red… which I have not figured out how to do.

To make it red the day of I did a conditional that said If “due date” = “current date” then make circle red
I’ve also done some that are like If due date = current date minus 2 days…
But how can I make one that said like, due date > current date or after current date???

Any ideas would be extremely appreciated as I am at a loss.

This topic was automatically closed after 70 days. New replies are no longer allowed.