Sathisc;337136 Wrote:
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 helpYou would need to use the ontime method, starting the timer when the
cell becomes active and ending the timer if the cell beomes filled or
the row coloured red.

It's not an exact science as the timer will restart should you move
cells even if data hasn't been entered previously!


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=94274