set a limit

[derek]

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??

 

[gls858]

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

 

[Bob Phillips]

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)