Conditional format between times

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. :slight_smile:

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,



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

1 Like

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

1 Like

Thanks @Chrisitaan,

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


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