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
|