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