Refreshing Date or Now function

Hi Guys,

Dont know wether this is possible!
But is it possible to have a function/formula/macro so that I can have a cell display the current date and time.

I know its possible using

 =now()

formula

however it does not get refreshed automatically - I want these cells to auto refresh with the current time say everyone hour or so.

The reason for this is I want to have a cloumn which show the correct number of days and time Lapsed since a request was created.

And these fileds will go Red if the day count is above 5 days.

Since there would be hundreds of rows added daily its not feasible to change each and every cell everday if you get my point

Thanks

Cross posted at http://www.mrexcel.com/forum/showthr...21#post1684421

have a look here
http://www.cpearson.com/excel/OnTime.aspx

your code
in the bit where it says enter your code should look like this

Sub The_Sub()
 [a1] = Now
   ' Call StartTimer to schedule the procedure again
   StartTimer
End Sub

where a1 is the cell your time is to be