Can I setup conditional formatting based on a time function?

Kenya Asbill

Hello! Is it possible to setup conditional formatting based on a time function? For example, I want a cell to turn red if it hasn't been updated by 12noon. Or, I want a cell to turn red if the current time is after 2pm.

Paul Newcome

This can get a little tricky and will involve a separate sheet with automations that can be used for cell linking.

The first thing you will need to do is convert the timestamp in the [Modified (date)] column into usable numbers.

Are you able to provide a screenshot of the modified column so that I can see the time formatting?

Kenya Asbill

@Paul Newcome Thanks for the response! I will send you an update on Monday 03/29.

Kenya Asbill

@Paul Newcome We are still working on this. I will post an update as soon as one is available.

robin_polly108876

@Paul Newcome I want to tag in on this and ask a question about time similar to this one. If I have a date and time stamp and i have separated them from each other into separate columns and then I added time to the time column based on how many hours a rental agreement is. Is there a way to now be alerted if the item is not checked in by the expected return time? I have been able to alert based on the date that is separated but I can't figure out the alert for the time.

Paul Newcome

@robin_polly108876 Take a look through THIS THREAD where we did something very similar.