set a limit

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

derek - 26 May 2005 22:25 GMT

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

Reply to this Message

gls858 - 26 May 2005 22:56 GMT

> 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

Reply to this Message

Bob Phillips - 26 May 2005 23:01 GMT

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

Signature

HTH

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

Reply to this Message