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 
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