Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Upcoming Date alerts
Is there a way I can have an Excel 2003 worksheet notify me of upcoming
dates? Ex: I have a spreadsheet tracking safety course expirey dates, and would like to have the cells highlight prior to that date, say 1 month in advance. Will conditional formatting do this, and if so, how? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Upcoming Date alerts
TRY:
Assuming dates are in column A, highlight column A, then in Conditional Formatting set "Formula is" to =(A1<=TODAY()+30) and set to required colour. HTH "Trenton" wrote: Is there a way I can have an Excel 2003 worksheet notify me of upcoming dates? Ex: I have a spreadsheet tracking safety course expirey dates, and would like to have the cells highlight prior to that date, say 1 month in advance. Will conditional formatting do this, and if so, how? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Upcoming Date alerts
Are start and end cell #'s required?
"Toppers" wrote: TRY: Assuming dates are in column A, highlight column A, then in Conditional Formatting set "Formula is" to =(A1<=TODAY()+30) and set to required colour. HTH "Trenton" wrote: Is there a way I can have an Excel 2003 worksheet notify me of upcoming dates? Ex: I have a spreadsheet tracking safety course expirey dates, and would like to have the cells highlight prior to that date, say 1 month in advance. Will conditional formatting do this, and if so, how? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Upcoming Date alerts
For some reason, it highlights all sorts of cells, but not the ones I need.
Any suggestions? "Toppers" wrote: TRY: Assuming dates are in column A, highlight column A, then in Conditional Formatting set "Formula is" to =(A1<=TODAY()+30) and set to required colour. HTH "Trenton" wrote: Is there a way I can have an Excel 2003 worksheet notify me of upcoming dates? Ex: I have a spreadsheet tracking safety course expirey dates, and would like to have the cells highlight prior to that date, say 1 month in advance. Will conditional formatting do this, and if so, how? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Upcoming Date alerts
The current test should highlight any expiry date within 30 days of today i.e
any dates before 30th June 2006. Is this what is required or have I misunderstood? "Trenton" wrote: For some reason, it highlights all sorts of cells, but not the ones I need. Any suggestions? "Toppers" wrote: TRY: Assuming dates are in column A, highlight column A, then in Conditional Formatting set "Formula is" to =(A1<=TODAY()+30) and set to required colour. HTH "Trenton" wrote: Is there a way I can have an Excel 2003 worksheet notify me of upcoming dates? Ex: I have a spreadsheet tracking safety course expirey dates, and would like to have the cells highlight prior to that date, say 1 month in advance. Will conditional formatting do this, and if so, how? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Upcoming Date alerts
Your understanding is correct. My spreadsheet, however,isn't doing it. In my
case, the datres I'm tracking are in column G, starting @ G6 through G77. I've tried highlightong the entire G column and inputting your formula, as well as just highlighting G6-G77. Each time, it highlights all sorts of cells, some with dates such as 10-Oct-08, but ironically not 23-Jun-06. I've also tried changing the cell date format to an all numeric version, with no change. "Toppers" wrote: The current test should highlight any expiry date within 30 days of today i.e any dates before 30th June 2006. Is this what is required or have I misunderstood? "Trenton" wrote: For some reason, it highlights all sorts of cells, but not the ones I need. Any suggestions? "Toppers" wrote: TRY: Assuming dates are in column A, highlight column A, then in Conditional Formatting set "Formula is" to =(A1<=TODAY()+30) and set to required colour. HTH "Trenton" wrote: Is there a way I can have an Excel 2003 worksheet notify me of upcoming dates? Ex: I have a spreadsheet tracking safety course expirey dates, and would like to have the cells highlight prior to that date, say 1 month in advance. Will conditional formatting do this, and if so, how? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Upcoming Date alerts
Check that (some of) the fields are not formatted as text rather than dates.
I have re-checked my formatting and it works with date fields but fails if they are text fields. "Trenton" wrote: Your understanding is correct. My spreadsheet, however,isn't doing it. In my case, the datres I'm tracking are in column G, starting @ G6 through G77. I've tried highlightong the entire G column and inputting your formula, as well as just highlighting G6-G77. Each time, it highlights all sorts of cells, some with dates such as 10-Oct-08, but ironically not 23-Jun-06. I've also tried changing the cell date format to an all numeric version, with no change. "Toppers" wrote: The current test should highlight any expiry date within 30 days of today i.e any dates before 30th June 2006. Is this what is required or have I misunderstood? "Trenton" wrote: For some reason, it highlights all sorts of cells, but not the ones I need. Any suggestions? "Toppers" wrote: TRY: Assuming dates are in column A, highlight column A, then in Conditional Formatting set "Formula is" to =(A1<=TODAY()+30) and set to required colour. HTH "Trenton" wrote: Is there a way I can have an Excel 2003 worksheet notify me of upcoming dates? Ex: I have a spreadsheet tracking safety course expirey dates, and would like to have the cells highlight prior to that date, say 1 month in advance. Will conditional formatting do this, and if so, how? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Automatic, Non-Updating Date Stamp | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Adding XY days to date in cells | Excel Discussion (Misc queries) | |||
Another Date issue. | Excel Worksheet Functions | |||
compute upcoming Sunday date in a cell | Excel Worksheet Functions |