notifications

Bardrill

New Member
Joined
Jul 31, 2010
Messages
4
I am in the process of making a workbook to capture employee training.
Each employee will have their own page tab for their training records.
Some cells are formatted so that when the date expires the cell turns red to notify you that it has expired.
Other cells are formatted so that you can enter the date that the training was done and it will turn yellow 1 month before it is due for renewal and then red when it expires.

My question is:
Is it possible to have a pop up or message displayed when these cells expire when you open the workbook no matter which page tab you are in informing you.
Or is it possible to get a message or reminder in outlook.

Any help would be appreciated.:)
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Watch MrExcel Video

Forum statistics

Threads
1,122,519
Messages
5,596,635
Members
414,083
Latest member
Mrsash

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top