1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Help. Need help with date triggers in Excel

Discussion in 'Business Applications' started by Peaker, Jun 7, 2008.

Thread Status:
Not open for further replies.
Advertisement
  1. Peaker

    Peaker Thread Starter

    Joined:
    Nov 23, 2001
    Messages:
    249
    Hi guys,

    Pretty new to Excel really, know the basic stuff but the intermediate stuff is beyond me for now. Hence this post.

    What I want to do is this:

    Have a field on my spreadsheet that contains a fixed date say 06/06/2008 and this cell would be green or a cell next to it would be green.

    Now as the date reaches say 28 days in the future, so 04/07/2008 I want the colour to change to red.

    Is this possible and if so, how do I do it???

    Thanks,

    Peaker. :)
     
  2. Sponsor

  3. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,400
  4. pillainp

    pillainp

    Joined:
    Dec 11, 2007
    Messages:
    138
    Use conditional formating. Easiest way out.
     
  5. Peaker

    Peaker Thread Starter

    Joined:
    Nov 23, 2001
    Messages:
    249
    Right, got my head round the basis of conditional formatting howvever.....

    I want the formula to be say =B3>(28 days in the future). How do I do this? And I'll need the date to change daily as well automatically. For info B3 will be a fixed date.

    Help!!!
     
  6. Peaker

    Peaker Thread Starter

    Joined:
    Nov 23, 2001
    Messages:
    249
    And by saying 28 days in the future I mean that B3 (the fixed date) should turn red if the date contained in it is 28 days or more in the past....

    Confusing myself now....:confused:
     
  7. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,400
    Using the example Spreadsheet that I pointed out, in I3 place
    =NOW()-28
    in B3 place your date
    in the conditional formating use the same formula as the example
     
  8. Peaker

    Peaker Thread Starter

    Joined:
    Nov 23, 2001
    Messages:
    249
    Excellent.

    All sorted!!

    Thanks chaps. (y)
     
  9. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/719295