Home

Conditional Formatting - Automatic Notificatons

%3CLINGO-SUB%20id%3D%22lingo-sub-804383%22%20slang%3D%22en-US%22%3EConditional%20Formatting%20-%20Automatic%20Notificatons%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804383%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20currently%20have%20several%20registers%20to%20manage%20my%20test%20equipment%20calibration%20dates.%20At%20present%20we%20use%20a%20%22traffic%20light%22%20system%20based%20on%20date%20that%20the%20equipment%20needs%20to%20be%20calibrated%20and%20then%20set%20traffic%20light%20dates%20prior%20to%20this%20date%20to%20colour%20code%20it%20to%20alert%20that%20the%20item%20needs%20calibrated.%20Is%20there%20any%20way%20in%20excel%20that%20I%20can%20make%20this%20register%20email%20or%20send%20out%20notifications%20to%20me%20that%20dates%20are%20approaching%20for%20equipment%20that%20needs%20calibrated.%20Right%20now%20we%20have%20to%20manually%20filter%20each%20register%20by%20colour%20to%20identify%20what%20is%20due%20for%20calibration.%3C%2FP%3E%3CP%3EHope%20that%20someone%20knows%20the%20answer%20or%20can%20suggest%20the%20use%20of%20a%20different%20application%20or%20method%20to%20manage%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20approx%20500%20items%20that%20I%20manually%20manage%20at%20present%2C%20sample%20of%20this%20register%20is%20attached%20here%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EDave%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-804383%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-804694%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%20-%20Automatic%20Notificatons%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804694%22%20slang%3D%22en-US%22%3E%3CP%3EDave%2C%3C%2FP%3E%3CP%3EYou%20can%20write%20a%20small%20VBA%20macro%20in%20your%20Excel%20to%20do%20this.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EVBA%20coding%20is%20not%20very%20difficult%20to%20learn%2C%20there%20are%20plenty%20of%20tutorials%20and%20sample%20code%26nbsp%3B%20in%20the%20internet%20to%20do%20these%20kind%20of%20automations.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20might%20want%20have%20a%20Daily%20script%20to%20check%20the%20inspection%20dates%20falling%20in%20next%20X%20number%20of%20days%20(or%20overdue)%20and%20send%20a%20consolidated%20email%20notification.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Dave_Hutch
Occasional Visitor

Hello all.

 

I currently have several registers to manage my test equipment calibration dates. At present we use a "traffic light" system based on date that the equipment needs to be calibrated and then set traffic light dates prior to this date to colour code it to alert that the item needs calibrated. Is there any way in excel that I can make this register email or send out notifications to me that dates are approaching for equipment that needs calibrated. Right now we have to manually filter each register by colour to identify what is due for calibration.

Hope that someone knows the answer or can suggest the use of a different application or method to manage this?

 

I have approx 500 items that I manually manage at present, sample of this register is attached here

 

Thanks

Dave

 

1 Reply

Dave,

You can write a small VBA macro in your Excel to do this.  

VBA coding is not very difficult to learn, there are plenty of tutorials and sample code  in the internet to do these kind of automations.  

You might want have a Daily script to check the inspection dates falling in next X number of days (or overdue) and send a consolidated email notification.  

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies