making excel to notifying you about expire dates on your sheet

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
 
M

Mike H

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
 
A

Andymackk

Thanks Mike,
That helped me!

Andy

Mike H said:
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
Click to expand...
 
Top