Conditional format between times

[heatherfeather]

Hello! I tried searching the community and couldn’t find anything that helped me with a formula.

I have two cells that contain times, for instance 11:00 am and 12:00 pm. I want to use conditional format to automatically highlight a row if the current time is between the times in the two cells of that row.

Thanks in advance for your help! I am very familiar with Excel formulas but still getting used to working with Coda formulas.

[Thierryvm]

Hi @heatherfeather,

I suggest you use a formula thisRow.Date= Today() OR thisRow.Date<= (Today() + 7) like this one but you can adapt it to your needs

Or thisRow.Date=ToDateTime(“8/31/2022, 11:00 AM”) OR thisRow.Date=ToDate(“8/31/2022, 12:00 AM”)

Good to you,

Thierry

[Christiaan_Huizer]

welcome @heatherfeather !
interesting question
let as assume you named the columns ‘from’ and ‘until’ like in my example
the condition to be met should be true
you need the time value of ‘any’ moment and for this we use: Now()…ToTime()

thisRow.From < Now().ToTime() and thisRow.Until > now().ToTime()

Enjoy, Cheers, Christiaan

[heatherfeather]

This solved my issue and I was able to get the correct row to highlight. Thank you so much!

[Thierryvm]

Thanks @Chrisitaan,

I was not in the right direction :(, fortunately there are pros to correct