making excel to notifying you about expire dates on your sheet
 

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

making excel to notifying you about expire dates on your sheet
 

You could use conditional formatting
Select your cell and then

Format|Conditional Format
Select formula is and enter this formula
=TODAY()-A120

Pick a colour

Mike

"F.M.H" wrote:

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

making excel to notifying you about expire dates on your sheet
 

thanks for you Mr. Moke H
but i need it in a message box
thank you in advance
F.M.H

"Mike H" wrote:

You could use conditional formatting
Select your cell and then

Format|Conditional Format
Select formula is and enter this formula
=TODAY()-A120

Pick a colour

Mike

"F.M.H" wrote:

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

making excel to notifying you about expire dates on your sheet
 

Thanks Mike,
That helped me!

Andy

"Mike H" wrote:

You could use conditional formatting
Select your cell and then

Format|Conditional Format
Select formula is and enter this formula
=TODAY()-A120

Pick a colour

Mike

"F.M.H" wrote:

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