| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there any way to alert you when you are approaching a date?
I have an excel spreadsheet with due dates in a cell. Is there anyway to
alert the reader a week before that due date? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there any way to alert you when you are approaching a date?
1. Select the cel/Range...say ColA..
2. From menu FormatConditional Formatting 3. For Condition1Select 'Formula Is' and enter the below formula =AND(A10,A1<TODAY()+7) Cell A1 in the above formula is the first cell in the selection 4. Click Format ButtonPattern and select your color (say Red) 5. Hit OK If this post helps click Yes --------------- Jacob Skaria "Tee" wrote: I have an excel spreadsheet with due dates in a cell. Is there anyway to alert the reader a week before that due date? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there any way to alert you when you are approaching a date?
Yes. Look at help for "Conditional Formatting".
-- David Biddulph "Tee" wrote in message ... I have an excel spreadsheet with due dates in a cell. Is there anyway to alert the reader a week before that due date? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get a cell to highlight when a deadline date approaching | Excel Worksheet Functions | |||
| Conditional Date Alert | Excel Discussion (Misc queries) | |||
| Alert date | Excel Worksheet Functions | |||
| Rapidly Approaching Meltdown | Excel Worksheet Functions | |||
| Date Alert | Excel Worksheet Functions | |||
Linear Mode
