Expiration Date Notification

L

lctrues

Board Regular
Joined
Oct 13, 2002
Messages
103
Is there anyway to have some type of notification appear when you open a workbook that may contain one or more dates that have expired? :rolleyes:
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Sort by date Sort by votes
You can select the first cell with a date (assume A1)and use conditional formatting(Format>Conditional Formatting) with the formula =A1=Today()-1. Set the format to color the Pattern or the font (your choice). Then use the format painter to paint the other cells with this format
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Question
Popup to Notify of Expiring/Expired Dates
2
Replies
11
Views
314
Herakles
H
B
  • Solved
Set expiry date 10 days from opening workbook
2
Replies
11
Views
154
bptaw
B
Z
  • Question
Charting inventory by expiration date with projected levels based on sales
Replies
1
Views
176
sijpie
sijpie
W
  • Question
Expiring date with message box
2
Replies
10
Views
399
Skyybot
Skyybot
B
  • Solved
Combining vba
Replies
1
Views
90
Joe4
Joe4

Forum statistics

Threads
1,203,489
Messages
6,055,724
Members
444,814
Latest member
AutomateDifficulty

Share this page

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