Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jun 2012
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Highlight Approaching due date & ideally display a pop up box warning

    Hi everyone,
    I started my first big boy job and have been asked to attempt to create a pop up box for the following spread sheet.

    I have attached a copy of the spreadsheet, basically column R shows a number representing the day of the month that an bill is due, this number is static it does not change from month to month. I need to write a formula that will either highlight the cell when the current date is within five days of this number or add a column that would display an X next to the column R which would indicate whether the item is within five days of it's due date.

    What would be even more ideal is having a macro that would generate a pop up message and say "Due within 5 days" and references column D. Any help would be greatly appreciated
    Attached Files Attached Files
    Last edited by Vmedin2; 2012-06-09 at 17:26.

  2. #2
    New Lounger
    Join Date
    Jan 2012
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Is this what you were after?

    Windy
    Attached Files Attached Files

Posting Permissions

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