set a limit
 

I am a generator mechanic and Im trying to use excel for a maintaince
program, the gen set i work on have to be serviced ever 200, 500 and 1000
hours, this is a problem because the gen's run 24 hours a day. Is there a
way that i can input the hours of each gen set and excel chang the color or
somthing to notify me that service is needed??

derek wrote:
I am a generator mechanic and Im trying to use excel for a maintaince
program, the gen set i work on have to be serviced ever 200, 500 and 1000
hours, this is a problem because the gen's run 24 hours a day. Is there a
way that i can input the hours of each gen set and excel chang the color or
somthing to notify me that service is needed??

Take a look at conditional formatting. You don't say how your table is set
up but yes it can be done.

gls858

Setup conditional formatting on the cells.

Select all the cells, say starting in A2, goto CF, and use formulas of
=A2<NOW()-1000/24
=A2<NOW()-500/24
=A2<NOW()-200/24

in that order, and set colours accordingly

--

HTH

RP
(remove nothere from the email address if mailing direct)


"derek" wrote in message
...
I am a generator mechanic and Im trying to use excel for a maintaince
program, the gen set i work on have to be serviced ever 200, 500 and 1000
hours, this is a problem because the gen's run 24 hours a day. Is there a
way that i can input the hours of each gen set and excel chang the color
or
somthing to notify me that service is needed??