View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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