set a warning in excel after a certain amount of days
 

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

set a warning in excel after a certain amount of days
 

Hi George
Have a look at using an ONTIME Macro

Regards
Michael M

"George" wrote:

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

set a warning in excel after a certain amount of days
 

Sorry George
Forgot to add the link
http://search.freefind.com/find.html... LL&search=all

HTH
Michael M

"George" wrote:

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

set a warning in excel after a certain amount of days
 

From when? If you mean when the computer clock date changes to another day
and another time? Use formatconditional 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)


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