# Change color if date has passed? Conditional formatting question

**URL:** <https://forum.bubble.io/t/change-color-if-date-has-passed-conditional-formatting-question/13614>\
**Category:** Need help\
**Created:** [May 19, 2017, 8:46pm UTC](https://forum.bubble.io/t/change-color-if-date-has-passed-conditional-formatting-question/13614 "2017-05-19T20:46:43Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dave2](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/dave2/32/12225_2.png) [@dave2](https://forum.bubble.io/u/dave2)\
**Post date:** [May 19, 2017, 8:46pm UTC](https://forum.bubble.io/t/change-color-if-date-has-passed-conditional-formatting-question/13614/1 "2017-05-19T20:46:43Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/bubble/original/3X/2/8/2847faa74692c2ffa5d939d3dc3724cdd060d247.png) [@system](https://forum.bubble.io/u/system)\
**Post date:** [July 28, 2017, 8:46pm UTC](https://forum.bubble.io/t/change-color-if-date-has-passed-conditional-formatting-question/13614/2 "2017-07-28T20:46:47Z")

</div>

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