+ Reply to Thread
Results 1 to 5 of 5

Calendar: deadline formatting

  1. #1
    Registered User
    Join Date
    05-19-2010
    Location
    Atlanta
    MS-Off Ver
    Excel 2007
    Posts
    4

    Calendar: deadline formatting

    Made an excel calendar which serves as a "deadlines reminder" calendar.

    I want to be able to fill color on the final deadline. The script would fill in other mini deadlines based on the amount of WEEK-days (i.e. work days) from the final deadline.

    For example, if the final deadline is Tuesday, Feb 2, 2010, I would fill that with the color red (or some kind of marker). There are two mini deadlines that I want to autofill, one that is four days before that Tuesday, the other is 10 days. So I want the function/macro to fill Jan 27 (4 work days before) with a different color. And Jan 19 (10 days before) with yet another color.

    The problem is in ignoring the weekend days.

    Remember the point is to have a simple visual reminder of approaching deadlines, so I need the results on the first sheet of the file I uploaded. The second sheet is a linear list of dates in 2010; the solution will most likely use this and the workday function

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-19-2010
    Location
    Atlanta
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Calendar: deadline formatting

    Quote Originally Posted by reddick.ross View Post
    Made an excel calendar which serves as a "deadlines reminder" calendar.

    I want to be able to fill color on the final deadline. The script would fill in other mini deadlines based on the amount of WEEK-days (i.e. work days) from the final deadline.

    For example, if the final deadline is Tuesday, Feb 2, 2010, I would fill that with the color red (or some kind of marker). There are two mini deadlines that I want to autofill, one that is four days before that Tuesday, the other is 10 days. So I want the function/macro to fill Jan 27 (4 work days before) with a different color. And Jan 19 (10 days before) with yet another color.

    The problem is in ignoring the weekend days.

    Remember the point is to have a simple visual reminder of approaching deadlines, so I need the results on the first sheet of the file I uploaded. The second sheet is a linear list of dates in 2010; the solution will most likely use this and the workday function

    Thanks in advance.
    maybe something using FN weekday also?

  3. #3
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Re: Calendar: deadline formatting

    Hi
    I would like to upload J-Walk Yearly Calendar
    It may work for you

    Answering to your question, you can use conditional formatting
    Highlight all month (B6:X36) got to Conditional formatting on the Home Tab and and select New Rule from dropdown.

    I in window select the last option and type followin formula
    =$A$1=B6

    Where A1 is deadline date....
    Then press format button and select appropriate formatting for deadline date and press OK in all windows
    This must change appearance of those date in your calendar...

    Truely believe that this would help you!!!)))
    Cheeeeers
    Attached Files Attached Files
    Люди, питающие благие намерения, как раз и становятся чудовищами.

    Regards, «Born in USSR»
    Vusal M Dadashev

    Baku, Azerbaijan

  4. #4
    Registered User
    Join Date
    05-19-2010
    Location
    Atlanta
    MS-Off Ver
    Excel 2007
    Posts
    4

    Cool Re: Calendar: deadline formatting

    Quote Originally Posted by contaminated View Post
    Hi
    I would like to upload J-Walk Yearly Calendar
    It may work for you

    Answering to your question, you can use conditional formatting
    Highlight all month (B6:X36) got to Conditional formatting on the Home Tab and and select New Rule from dropdown.

    I in window select the last option and type followin formula
    =$A$1=B6

    Where A1 is deadline date....
    Then press format button and select appropriate formatting for deadline date and press OK in all windows
    This must change appearance of those date in your calendar...

    Truely believe that this would help you!!!)))
    Cheeeeers
    This is getting closer. I like being able to switch the years.

    But I guess whats still missing is this: I want to fill color red *manually* on a given date; the final deadline. Then have a macro or function that reads the calendar, testing for any cells with said red fill. Then the macro performs the color filling on the mini deadline(s) that lead up to the final deadline...

    anymore tips for the programming gods?!?!
    thanks
    Last edited by reddick.ross; 05-19-2010 at 05:02 PM. Reason: anyone...i know this is a challenge

  5. #5
    Registered User
    Join Date
    05-19-2010
    Location
    Atlanta
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Calendar: deadline formatting

    Quote Originally Posted by reddick.ross View Post
    This is getting closer. I like being able to switch the years.

    But I guess whats still missing is this: I want to fill color red *manually* on a given date; the final deadline. Then have a macro or function that reads the calendar, testing for any cells with said red fill. Then the macro performs the color filling on the mini deadline(s) that lead up to the final deadline...

    anymore tips for the programming gods?!?!
    thanks
    anyone...i know this is challenging

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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