Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
how do i save a large amount of data in a worksheet excel 4 | Excel Worksheet Functions | |||
Final days for regular registration - London Excel User Conference - July 19-21 | Excel Worksheet Functions | |||
Last days for Early Bird Registration - Excel User Conference | Excel Discussion (Misc queries) | |||
Saving Excel files takes a huge amount of time | Excel Discussion (Misc queries) |