+ Reply to Thread
Results 1 to 1 of 1

Automatically formatting borders - Updating format based on dates

  1. #1
    Registered User
    Join Date
    01-22-2013
    Location
    Hawaii
    MS-Off Ver
    Excel 2003
    Posts
    34

    Automatically formatting borders - Updating format based on dates

    I have the attached file. File is used to generate project timelines. All project information is entered under the projects tab and once entered, user clicks on the Render Timeline Button and then can see the timeline generated under the Timeline tab. Timeline consists of multiple phases that are color coded on timeline.

    A couple of issues:

    1. I would like it so that borders (black gridlines) are automatically placed around all content (not the entire sheet, just the rows and columns that contain information).
    2. Currently, after the first project is entered, a user must enter start and end dates for the planning and scope phase (columns F and G in the project tab). If they do not enter any dates, additional projects will not show up on the timeline. At times, projects may not need this phase (or other phases for that matter) and I would like to see them render on ther timeline if those dates (for planning and scope) were not entered.
    3. At times project phases may overlap. Currently, if a phase ends on 9/27/2016 and the next phase begins on 9/25/2016, the original phase end date will not reflect the original phase end date color, but will reflect the new phase color instead. I want to be able to show the original phase color regardless of the overlap.

    Thanks for the help.
    Attached Files Attached Files

+ 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. [SOLVED] formatting pivot table report (borders automatically showing)...
    By Perplexed in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-22-2014, 02:29 PM
  2. [SOLVED] Format to add row borders based on number of instances
    By Pierce Quality in forum Excel General
    Replies: 9
    Last Post: 08-01-2013, 09:33 AM
  3. [SOLVED] Updating Dates Format
    By cheddarthief in forum Excel General
    Replies: 3
    Last Post: 01-31-2013, 03:49 PM
  4. VBA: automatically input non-updating dates?
    By Jedouard in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-31-2010, 11:42 AM
  5. Automatically Format Cell Borders
    By newbie1234 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-27-2008, 07:09 AM
  6. [SOLVED] Updating Dates to Next Specific Weekday Automatically
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2006, 07:30 PM
  7. automatically Updating Dates
    By trantkim1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-20-2005, 11:23 PM

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