+ Reply to Thread
Results 1 to 2 of 2

Gantt Chart - Enhancing a Project Plan

  1. #1
    Forum Contributor
    Join Date
    03-19-2016
    Location
    Chicago, IL
    MS-Off Ver
    Office 2016 Professional
    Posts
    388

    Gantt Chart - Enhancing a Project Plan

    See the attached .xls

    I currently have developed a project plan with tasks listed and a gantt chart providing dates according to 'Start Date' entered and 'Days'.

    I want to enhance this project plan to do the following:

    1) Is there a way to lock down what a user can enter? They need to be able to enter the 'Start Date' (Column E7) and the Days Columns (starting with D7 -> D18). I don't want a user to be able to make any other updates to any other cells.

    2) Can the Row be highlighted (say Columns B and C) be highlighted with where the status of the order should be, based on TODAY. For example, if today is 08/02/2016, Column B9/C9 should be highlighted.

    3) My Gantt chart - starts with the 'Start Date', but only goes out as far as I manually do; Could this be automated to go out, for example, 60 days, on it's own?

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Gantt Chart - Enhancing a Project Plan

    1)How to lock individual cells in a worksheet.
    https://support.microsoft.com/en-us/kb/214081

    2) You could use conditional formatting
    3) Drag down your fomulas and such and then just hide anything not visible yet...?
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Adding conditional formatting (new rules) to gantt project plan
    By tnasa in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-12-2014, 11:05 AM
  2. Trying to export Gantt Chart from MS-Project
    By talented77 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-30-2014, 02:39 PM
  3. Recreate Gantt Chart logic used in Microsoft Project in EXCEL
    By skyline255 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-28-2013, 12:54 AM
  4. Gantt Chart -Conditional Formatting for project status
    By llattrell in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-30-2013, 05:00 PM
  5. Tracking Project With Gantt Chart
    By sanlen in forum Excel General
    Replies: 15
    Last Post: 08-31-2010, 09:48 PM
  6. Project Plan Creation in Excel (Gantt Charts)
    By leeb1977 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-19-2008, 05:58 AM
  7. Replies: 2
    Last Post: 11-19-2005, 12:10 AM

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