Change text color when specified date is reached

Hi All, I think I have managed to do this in the past but have completely forgotten the process.

Basically I have a data type “task” with a field “follow up date” I want to create a condition when text in a repeating group of tasks is changed when the “follow up date” has exceeded 5 days, 10 days etc.

Would appreciate assistance in the conditional/state solution to this. Thanks

Hi @rosewaterbrands

Try this :

Current date time - current cell’s task’s follow up date: format as days > 5 (or 10).



Awesome stuff, This works perfectly. Thanks.