I have attached an example. I am trying to make the time cell change color to red after 60 minutes have passed. please let me know if there is a way to do this. Thank you
I have attached an example. I am trying to make the time cell change color to red after 60 minutes have passed. please let me know if there is a way to do this. Thank you
so F31 shows the time of last check
what cell are you wanting to changing colour
if you use conditional formatting and change the format of the time cell to time
in the conditional format you use
=IF(TIME(HOUR(NOW()),MINUTE(NOW()),0) >TIME(HOUR(G32)+1,MINUTE(G32),0),TRUE,FALSE)
and then copy the format down
i have shown how this works in the attached sheet
you need to format the time checked as Time - I use HH:MM
and enter as time
09:17 for example for 9.17am
i have shown the calculation in columns I,J,K so you can see what happens
as the spreadsheet is using now() - the system time
just change the entries in column G to see what happens
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks