Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DATE ALARM
I WANT TO KNOW IF THERE IS A FORMULA THAT WHEN I PUT A DATE IN. iT WILL TELL
ME HOW CLOSE I'M GETTING. OR IT NOTIFS ME OF THE DATE. BLINKING I HAVE ALMOST ALL EXCEL BOOKS I THOUGHT THAT I SAW IT IN THERE SOME WHERE. THANKS |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
DATE ALARM
Date differences can be computed using normal arithmetic. When you say "..
how close I'm getting..", getting close to what? I guess you had better start searching ALL those books..... -- Regards, Nigel "LANCE" wrote in message ... I WANT TO KNOW IF THERE IS A FORMULA THAT WHEN I PUT A DATE IN. iT WILL TELL ME HOW CLOSE I'M GETTING. OR IT NOTIFS ME OF THE DATE. BLINKING I HAVE ALMOST ALL EXCEL BOOKS I THOUGHT THAT I SAW IT IN THERE SOME WHERE. THANKS |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
DATE ALARM
Please drop the all caps.
You can use Conditional Formatting to give a cell a background color when the date entered is near a pre-set date. =E3$G$3-7 where G3 is pre-set date and E3 has the entered date. Gord Dibben MS Excel MVP On Thu, 3 Jul 2008 23:16:00 -0700, LANCE wrote: I WANT TO KNOW IF THERE IS A FORMULA THAT WHEN I PUT A DATE IN. iT WILL TELL ME HOW CLOSE I'M GETTING. OR IT NOTIFS ME OF THE DATE. BLINKING I HAVE ALMOST ALL EXCEL BOOKS I THOUGHT THAT I SAW IT IN THERE SOME WHERE. THANKS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
alarm on a date cell | Excel Worksheet Functions | |||
alarm on a date cell? | Excel Worksheet Functions | |||
Can i set a cell to alarm if a date isnt enterd before a set date | Excel Worksheet Functions | |||
can I set a date alarm in Excel | Excel Discussion (Misc queries) | |||
how can I set an alarm for when a date passes? | Excel Discussion (Misc queries) |