Time left Conditional Formating

[Eva_Folch]

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!

Eva

[Christiaan_Huizer]

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

[Eva_Folch]

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