| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can i set a cell to alarm if a date isnt enterd before a set date
I would like to be able to alarm the fact that a date has not been entered
into the cell before a set date. IE: We sent a Drawing for approval on 10-nov-07. This is placed in cell H-7. We expect to see a reply by 15-nov-07. Can i use a fromula to alert me if this date is not inserted into cell H-8? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can i set a cell to alarm if a date isnt enterd before a set date
On Nov 15, 3:22 pm, davio wrote:
I would like to be able to alarm the fact that a date has not been entered into the cell before a set date. IE: We sent a Drawing for approval on 10-nov-07. This is placed in cell H-7. We expect to see a reply by 15-nov-07. Can i use a fromula to alert me if this date is not inserted into cell H-8? Do you want to set off the alarm if no date is entered at all, or if the date is not entered until 15-nov-07? Carlo |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can i set a cell to alarm if a date isnt enterd before a set d
Alarm if no date is entered by the predtermined date
"carlo" wrote: On Nov 15, 3:22 pm, davio wrote: I would like to be able to alarm the fact that a date has not been entered into the cell before a set date. IE: We sent a Drawing for approval on 10-nov-07. This is placed in cell H-7. We expect to see a reply by 15-nov-07. Can i use a fromula to alert me if this date is not inserted into cell H-8? Do you want to set off the alarm if no date is entered at all, or if the date is not entered until 15-nov-07? Carlo |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can i set a cell to alarm if a date isnt enterd before a set d
Alarm would sound if a date is not enterd into the cell before the preset date. dave |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can i set a cell to alarm if a date isnt enterd before a set d
If preset date would be H7 + 5 days.
open conditional formatting in H8 and enter formula (not value): =AND(H7+5<TODAY(),H8="") then set the format to red, or whatever you think is alarm. hth Carlo On Nov 15, 4:26 pm, davio wrote: Alarm would sound if a date is not enterd into the cell before the preset date. dave |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I set a date alarm in Excel | Excel Discussion (Misc queries) | |||
| can't keep 1-1 from becoming Jan-1, it isnt a date | Excel Discussion (Misc queries) | |||
| alarm a date in excel to outlook calendar | Excel Discussion (Misc queries) | |||
| How to set up alarm for cell has entry as date when it expires? | Excel Worksheet Functions | |||
| how can I set an alarm for when a date passes? | Excel Discussion (Misc queries) | |||
Linear Mode
