Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    New Jersey
    Posts
    103
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Hi,

    I attached a sample spreadsheet of what I am trying to do. Basically I am going to have a list of projects that are scheduled in my department. What I would like to do is add the project name, start and end date and automatically the columns highlight for the months that pertain to the start and end date. See my sample attached. The spreadsheet is going to be used for planning and tracking of projects so it would be extremely helpful if I can have the swim lanes adjust accordingly.

    Any help woul be appreciated.

    Thank you!
    Attached Files Attached Files

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    There are several possible solutions. Try the attached.
    [attachment=90838:Test Rev A.xls]


    EDIT: This has two ways of doing it.
    [attachment=90839:Test Rev B.xls]
    Attached Files Attached Files

  3. #3
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    New Jersey
    Posts
    103
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Tim Sullivan View Post
    There are several possible solutions. Try the attached.
    [attachment=90838:Test Rev A.xls]


    EDIT: This has two ways of doing it.
    [attachment=90839:Test Rev B.xls]
    This is great! Conditional formatting with a formula. How do I adjust the formula to include more than a calendar year?

  4. #4
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    ...... How do I adjust the formula to include more than a calendar year?
    Need more info:
    How many years?
    Which years?
    Sample of date ranges needed?

  5. #5
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post
    Quote Originally Posted by Tim Sullivan View Post
    Need more info:
    How many years?
    Which years?
    Sample of date ranges needed?
    I think that Corden's request is satisfied with the attached.
    [attachment=90859:Test Rev C.xls]
    Attached Files Attached Files
    Regards
    Don

  6. #6
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    New Jersey
    Posts
    103
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Thank you Don and Tim! This was exactly what I was looking for. Appreciate your help

  7. #7
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    New Jersey
    Posts
    103
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Help with a conditional formatting formula

    Hi Don,

    I am trying to use the conditional formatting swim lane formula but I am having problems figuring out how to use it for multiple years on one row. Moreover, we work on a fiscal year so our year starts from April through March. I attached a sample copy of the excel spreadsheet I am trying to add the formula to. What am I doing wrong? Your help is very much appreciated!
    Attached Files Attached Files

  8. #8
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    By my reckoning it should look like the attached for those dates. (I converted your month headers into actual dates and formatted them to display the month only.)
    Attached Files Attached Files
    Regards,
    Rory

    Microsoft MVP - Excel

  9. #9
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    New Jersey
    Posts
    103
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Thumbs up Thank you!

    Quote Originally Posted by rory View Post
    By my reckoning it should look like the attached for those dates. (I converted your month headers into actual dates and formatted them to display the month only.)
    This is great and works perfectly! I appreciate your help.

Posting Permissions

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