Cell Change color if not updated by time

[Closed]
Report
-
Posts
60
Registration date
Monday December 21, 2009
Status
Member
Last seen
December 25, 2009
-
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.

1 reply

Posts
60
Registration date
Monday December 21, 2009
Status
Member
Last seen
December 25, 2009
10
you are thinking to give some coding in it but i think conditional formating may work for you have you try for it?
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month