Hey all..
New to the forum, so please be gentle.. hehe
I working in a busy office/communications orientated job, and I am wanting some help with a formula, if possible, that looks at the current real time, and if the current time equals the time in a particular cell, a pop-up Reminder Alert comes up (and flashes maybe)..
EG: If I put into cell B3 the time of 08:45, at the exact real time of 08:45 an Alert Pops up..
Or Again, If I put into cell B3 the time of 08:45, at 1 minute before the real time of 08:45 an Alert Pops up..
The input time into a cell will be changed daily, depending on different shifts, and different required reminders, so the formula does need to be flexible...
Oh I am also new to Macro's etc, so if you can guide me through that it would be greatly appreciated... Thx
Hope this all makes sense, and thank you so much in advance..
What you seek seems to be doable. One point you need to keep in mind is how many cells it needs to check and how frequently. Here is a similair issue, see if you it gives you some help
