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.
<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>
A | B | C | D | E | F | G | H | I | J | Kosher Y/N | L | M | N | O |
IG# | Date | no of count | total count per Rec | Supplier name | Supplier item number | Supplier 's BBD Use by date | Supplier 's lot numbers | Kosher Y/N | Country of Origin from container or COA | |||||
2/5/2018 | chris_7_h#yahoo.com | |||||||||||||