making excel to notifying you about expire dates on your sheet

  • Thread starter Thread starter F.M.H
  • Start date Start date
F

F.M.H

please can any one help me!
i have in column B some date and i want Excel to notifying me before these
date expired by 20 days in a messege box with the dates that will expired
thank you in advance
 
You could use conditional formatting
Select your cell and then

Format|Conditional Format
Select formula is and enter this formula
=TODAY()-A1>20

Pick a colour

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting dates 3
Access MS Access 2010 IIF statement to check if one date is in or out of range of two other dates (fields) 0
Function re:Dates in Conditional Formatting 1
Expire count down 5
EOMONTH, TODAY() and Conditional Formatting (Excel 2003) 1
Setting up an electrical register in Excel with expiry dates 1
Problem with "IF" function 8
How do I set up excel to let me know when a date has expired? 1

Back
Top