Cell Change color if not updated by time

Closed
Marshmallow - Dec 20, 2009 at 04:03 PM
lfefil Posts 60 Registration date Monday December 21, 2009 Status Member Last seen December 25, 2009 - Dec 24, 2009 at 11:00 AM
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 December 21, 2009 Status Member Last seen December 25, 2009 10
Dec 24, 2009 at 11:00 AM
you are thinking to give some coding in it but i think conditional formating may work for you have you try for it?
1