Cell Change color if not updated by time

Closed
Marshmallow - 20 Dec 2009 à 16:03
lfefil Posts 60 Registration date Monday 21 December 2009 Status Member Last seen 25 December 2009 - 24 Dec 2009 à 11:00
Hello,

Here goes, Hoping you can help with this. I am trying to make it so a cell will change to a red color if it is not updated by a specific time. The scenario is as follows. On a daily basis for tracking purposes i would put in a time of when i checked on something. If i dont update that cell by a specific time in the same day i want it to turn red to indicate to me that i have not updated it yet. Any help would be greatly appreciated.
Related:

1 response

lfefil Posts 60 Registration date Monday 21 December 2009 Status Member Last seen 25 December 2009 10
24 Dec 2009 à 11:00
you are thinking to give some coding in it but i think conditional formating may work for you have you try for it?