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]

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

[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)


"derek" <[email protected]> wrote in message
news:[email protected]...
> 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??