Hi- I'm new here, and have done a search, but could not find an answer
to my question.
I am trying to set up a database in Excel to track some medical
equipment that needs to be re-certified every 10K hours of use. Is
there any way to set it up so that I will be alerted when a particular
unit is approaching it's usage limit?
Please know that I am very new to this, and just learning.

Thanks,


cabbitt


--
cabbitt
------------------------------------------------------------------------
cabbitt's Profile: http://www.excelforum.com/member.php...o&userid=33086
View this thread: http://www.excelforum.com/showthread...hreadid=528980

It would be relatively easy to set up something using 'Data Validation' to
highlight the color of the machine name in RED when a set time (date)
approaches.
However, easy meaning calendar time/date.

How do you intend to monitor (record) machine *USAGE*?

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"cabbitt" wrote in
message ...

Hi- I'm new here, and have done a search, but could not find an answer
to my question.
I am trying to set up a database in Excel to track some medical
equipment that needs to be re-certified every 10K hours of use. Is
there any way to set it up so that I will be alerted when a particular
unit is approaching it's usage limit?
Please know that I am very new to this, and just learning.

Thanks,


cabbitt


--
cabbitt
------------------------------------------------------------------------
cabbitt's Profile:
http://www.excelforum.com/member.php...o&userid=33086
View this thread: http://www.excelforum.com/showthread...hreadid=528980