Excel reminders

Copan1795

New Member
Joined
Mar 20, 2015
Messages
43
My excel sheet is set up to go red when the item goes pasted the BBD. I want a email remnder two week before it goes past the BBD. is this possible? I would settle for a email for when the item goes past the BBD.



ABCDEFGHIJKosher Y/NLMNO
IG#Dateno of counttotal count per RecSupplier name Supplier item numberSupplier 's BBD Use by date Supplier 's lot numbersKosher Y/NCountry of Origin from container or COA Email
2/5/2018 chris_7_h#yahoo.com
<colgroup><col width="64" style="width: 48pt;" span="3"> <col width="98" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3421;"> <col width="64" style="width: 48pt;" span="4"> <col width="69" style="width: 52pt; mso-width-source: userset; mso-width-alt: 2420;"> <col width="64" style="width: 48pt;" span="4"> <col width="177" style="width: 133pt; mso-width-source: userset; mso-width-alt: 6167;"> <col width="64" style="width: 48pt;"> <tbody> </tbody>
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Forum statistics

Threads
1,215,279
Messages
6,124,030
Members
449,139
Latest member
sramesh1024

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
Back
Top