+ Reply to Thread
Results 1 to 3 of 3

Changing text/color after a time period?

  1. #1
    Registered User
    Join Date
    04-29-2005
    Posts
    15

    Changing text/color after a time period?

    I hope some of the brilliant Excel people here can help me out. What I am looking to do, is enter a date in a certain cell (if it helps conceptualize, the date that I ship something to someone). Is it possible to have that cell with the "ship date" in it, either change colors, or change the font size, or something, after 30 days have gone by? My reasoning is that the product I ship out, has to be back to me in 30 days, or a penalty will incur to the other party. I just want these fields that have exceeded the 30 day mark, to stick out, so I can easily identify them. Thanks for any help in advance!

    Rich

  2. #2
    Anne Troy
    Guest

    Re: Changing text/color after a time period?

    Try this:
    http://www.officearticles.com/excel/...soft_excel.htm
    *******************
    ~Anne Troy

    www.OfficeArticles.com


    "metalsped" <[email protected]> wrote
    in message news:[email protected]...
    >
    > I hope some of the brilliant Excel people here can help me out. What I
    > am looking to do, is enter a date in a certain cell (if it helps
    > conceptualize, the date that I ship something to someone). Is it
    > possible to have that cell with the "ship date" in it, either change
    > colors, or change the font size, or something, after 30 days have gone
    > by? My reasoning is that the product I ship out, has to be back to me
    > in 30 days, or a penalty will incur to the other party. I just want
    > these fields that have exceeded the 30 day mark, to stick out, so I can
    > easily identify them. Thanks for any help in advance!
    >
    > Rich
    >
    >
    > --
    > metalsped
    > ------------------------------------------------------------------------
    > metalsped's Profile:

    http://www.excelforum.com/member.php...o&userid=22824
    > View this thread: http://www.excelforum.com/showthread...hreadid=387488
    >




  3. #3
    Registered User
    Join Date
    04-29-2005
    Posts
    15
    Awesome! Once again, someone comes through for me. Thanks a lot Anne!

+ 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1