Any advice on setting alert for servicing hours
Sorry if posted to the wrong section -
I know you can set alerts in Excel for dates.. But I need it to set an alert for when a certain number is reached.
So every 250 hours, a forklift needs servicing. Is it possible to set an alert for when the number of current hours exceeds that number plus 250
Last edited by fizfilson; 10-14-2018 at 07:15 PM.
Show us what your worksheet looks like so that we can analyze and present a viable solution.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Example.JPG
It looks like that, excuse my terrible example
You could use CF in Column I using this formula.
setting fill color to red and apply that to your entire range.PHP Code:=mod($H2,250)=0
Also putting this formula in I2 and pulling down
gives you the remaining days when next service is due.PHP Code:=250-MOD($H2,250)
Last edited by bakerman2; 10-14-2018 at 08:22 PM.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
For some reason it's still not working. Maybe it might be easier to each day just check it myself and add a note, I seem to be terrible at this excel stuff
But thank you so much for your help
Post your workbook with desensitized data (if needed) so we can see how to help you further on this one.
@ Alan
Thanks for rep+. Much appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks