Assume that you buy a caterpillar, and for every 10 hours of work, you need to apply lubricant. For every 100, you need to replace a certain part. For 500 hours, you need to perform any given adjustment. For 1000 hours, you need to have it checked by a technician. The formula/s I need should take into account intervals, because a machine needs lubrication every 10 hours, and any other given service every X amount of hours. I hope I am getting my point across.
At our company we have several machines and each machine requires different services. My aim is to create an excel table wherein I type in the amount of work hours of each machine, and by means of conditional formatting I can tell which service needs to be done ASAP.
I would be greatly thankful to anyone who can help me out with this.
Thanks a lot in advance.