+ Reply to Thread
Results 1 to 12 of 12

Upcoming Date alerts

  1. #1
    Trenton
    Guest

    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. #2
    Toppers
    Guest

    RE: 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. #3
    Trenton
    Guest

    RE: 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. #4
    Trenton
    Guest

    RE: 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. #5
    Toppers
    Guest

    RE: 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. #6
    Trenton
    Guest

    RE: 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. #7
    Toppers
    Guest

    RE: 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. #8
    Toppers
    Guest

    RE: 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?


  9. #9
    Toppers
    Guest

    RE: 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?


  10. #10
    Trenton
    Guest

    RE: 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?


  11. #11
    Toppers
    Guest

    RE: 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?


  12. #12
    Trenton
    Guest

    RE: 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.07110 seconds
  • Memory Usage 9,107KB
  • Queries Executed 16 (?)
More Information
Template Usage (30):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (12)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (12)postbit_legacy
  • (12)postbit_wrapper
  • (4)showthread_bookmarksite
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (40):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php
  • ./includes/functions_prefix.php 

Hooks Called (44):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1