Hi,
I have built an excel spread sheet to monitor activities. In it I
use the function"NOW" and use a given time past this to give out a
warning via conditional formatting. It works fine for what I need
except for one snag! Somebody has to press F9 every five minutes.
Obviously this is a waste of time and not always done which makes the
system questionable. Anybody got any idea how I can get it to
automatically refresh/re calculate? I would be very grateful for any
advice on this one.


Regards

Dale