Time left Conditional Formating

This is provably very simple but somehow I can not manage.
I have a Column that Calculates the Time Left for a project:

[Delivery Date]-thisRow.[Start Date]

Now I want to have a conditional formatting that turns to RED when it’s 12h to Delivery Date. I tried this but it’s not working:

[Time Left] >= Hours() AND [Time Left] <= Hours() + 12

What am I doing wrong?

Thanks in advance!


hi @Eva_Folch , like this:

the table columns show the logic I applied right in the formula field of the conditional format

Let me know if this helps you further (or not)
cheers, christiaan


Works exactly how I wanted, thank a lot!
Greetings, Eva

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.