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? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Upcoming Date alerts
Perfect! Thank you! One last question, some of the cells are blank (IE no
course required for that person) is there an additional format to not highlight those? "Toppers" wrote: 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? |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Upcoming Date alerts
=and(a1<=today()+30,a1<"")
"Trenton" wrote: Perfect! Thank you! One last question, some of the cells are blank (IE no course required for that person) is there an additional format to not highlight those? "Toppers" wrote: 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? |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Upcoming Date alerts
Thank you for your assistance.
"Toppers" wrote: =and(a1<=today()+30,a1<"") "Trenton" wrote: Perfect! Thank you! One last question, some of the cells are blank (IE no course required for that person) is there an additional format to not highlight those? "Toppers" wrote: 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 |