set a limit

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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??
Click to expand...

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)
 
Back
Top