set a warning in excel after a certain amount of days

[Guest]

i am trying to set up a conditional format in excel to warn me when a certain
amount of time has passed

 

[Guest]

Hi George
Have a look at using an ONTIME Macro

Regards
Michael M

 

[Guest]

Sorry George
Forgot to add the lin
http://search.freefind.com/find.htm...&query=ONTIME&Find=Search&mode=ALL&search=all

HTH
Michael M

 

[Peo Sjoblom]

From when? If you mean when the computer clock date changes to another day
and another time? Use format>conditional formatting, formula is

=NOW()>=$B$2

select format

where B2 holds a date and a time like 08/28/06 21:30

if you are only interested when the day changes to another day use TODAY()
instead of NOW() and change B2 to just a date
--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email)