Hi,

I have a data in which i enter time in a cell. I need a macro like when
the cell's time is exceeding 45 mins form the system time the entire row
should change into red. But when any data is entered in Cell E1 the
alert needs to stop.

M.No Date Time Place Outcome
3059934009 7/5/2009 15.03 P0 5LX

In the above example the Time 15:03 is entered at real time i need an
alert or the entire cell turns into red when the system time is 15:48
exactly after 45 mins of the job time(15:03). If the outcome data is
filled in then the alert should get stop.

Many thanks for the help


--
Sathisc
------------------------------------------------------------------------
Sathisc's Profile: http://www.thecodecage.com/forumz/member.php?userid=187
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=94274