Conditional formatting between changing time values

Hello, I am trying to create a conditional format formula, that will change the colour of a row if the current is active between its ‘start date’ and ‘end date’ (fields).

Cheers for the helpers :slight_smile:

Hi @Yotam_Guttman, welcome to the community!

What you are probably looking for is something like
today() < [End Date] && today() > [Start Date] && [Active] == true()
not sure about the [Active] bit, but just added it in there if you are putting a checkbox for an active task or something.

1 Like