+ Reply to Thread
Results 1 to 11 of 11

Due date

  1. 08-09-2010, 05:22 AM #1
    MarryAnne
    MarryAnne is offline
    Registered User
    Join Date
    06-04-2009
    Location
    Cherok Tokun,Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    8

    Due date

    hello can anyone help me to solve a problem?...

    i have attach a file...

    hope anyone can help me...thanks a lot...
    Attached Files Attached Files
    Last edited by MarryAnne; 08-09-2010 at 09:35 AM.
    Reply With QuoteRegister To Reply
  2. 08-09-2010, 05:29 AM #2
    arthurbr
    arthurbr is offline
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Due date

    Something like this ? ( see attached) Ther is a conditional formatting and a test to enter the word "DUE"
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 08-09-2010, 06:11 AM #3
    MarryAnne
    MarryAnne is offline
    Registered User
    Join Date
    06-04-2009
    Location
    Cherok Tokun,Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Due date

    Quote Originally Posted by arthurbr View Post
    Something like this ? ( see attached) Ther is a conditional formatting and a test to enter the word "DUE"
    wow...impressive...
    thanks a lot mate...
    this is very helpful....
    thanks again...:-)

    OK...WHAT IF I WANT TO ADD COLOR IN THE CELL?...
    MEANS RED COLOR BECAUSE IT WILL SHOW MORE ALERT...
    Last edited by MarryAnne; 08-09-2010 at 06:20 AM.
    Reply With QuoteRegister To Reply
  4. 08-09-2010, 06:29 AM #4
    teylyn
    teylyn is offline
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Due date

    MaryAnne,

    in your next question, please describe the nature of the problem in the post, not just in the attachment. I for one, would like to know if I can contribute to an answer before downloading a workbook.

    And now, please mark your question as solved.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save
    Microsoft MVP
    http://www.teylyn.com
    Twitter: http://twitter.com/IngeborgNZ
    Reply With QuoteRegister To Reply
  5. 08-09-2010, 06:35 AM #5
    MarryAnne
    MarryAnne is offline
    Registered User
    Join Date
    06-04-2009
    Location
    Cherok Tokun,Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Due date

    OK...
    I AM SORRY...
    I plan to make a system. Which is like schedule system. I want a reminder come out like ALERT OR DUE..THEN THE CELL BECOME RED OR ATHER COLOR TO SHOW THE DATE IS DUE.
    Last edited by teylyn; 08-09-2010 at 06:40 AM. Reason: removed spurious quote
    Reply With QuoteRegister To Reply
  6. 08-09-2010, 06:40 AM #6
    teylyn
    teylyn is offline
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Due date

    please don't quote whole posts (why quote at all if you're just replying??). It just clutters up the forum and creates clean-up work for the moderators.
    Reply With QuoteRegister To Reply
  7. 08-09-2010, 06:45 AM #7
    MarryAnne
    MarryAnne is offline
    Registered User
    Join Date
    06-04-2009
    Location
    Cherok Tokun,Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Due date

    Once more i am sorry...
    So i am still don t get my answer...
    Please help me...
    Reply With QuoteRegister To Reply
  8. 08-09-2010, 06:46 AM #8
    arthurbr
    arthurbr is offline
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Due date

    You can adapt the color to your needs. Select the cell then Format - Conditional formatting and adapt the pattern as required. See also Conditional Formatting under XL Help
    Reply With QuoteRegister To Reply
  9. 08-09-2010, 07:14 AM #9
    MarryAnne
    MarryAnne is offline
    Registered User
    Join Date
    06-04-2009
    Location
    Cherok Tokun,Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Due date

    Allright....
    Thanks to those help me...
    Luv u all...
    Reply With QuoteRegister To Reply
  10. 03-21-2011, 10:14 PM #10
    MarryAnne
    MarryAnne is offline
    Registered User
    Join Date
    06-04-2009
    Location
    Cherok Tokun,Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Due date

    Ok....the previous task is done...
    What if i want the bell is ring one week before the due date?....
    Reply With QuoteRegister To Reply
  11. 03-22-2011, 05:13 AM #11
    teylyn
    teylyn is offline
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Due date

    Please start a new thread.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1