+ Reply to Thread
Results 1 to 3 of 3

Gantt Chart Formula Problem

  1. #1
    Forum Contributor
    Join Date
    07-22-2015
    Location
    San Francisco
    MS-Off Ver
    Mac 2011 Version 14.5.2
    Posts
    107

    Gantt Chart Formula Problem

    Hello,

    I am trying to write a formula for a Gantt chart in excel where the timeline is in months. I want the cells to return a 1 or a 0 so I can use conditional formatting g to complete the bars on the Gantt.

    I have written the formula I think should work, but it is not returning the write numbers in the cell.

    Is there anyone who may be able to help with this? I attach the spreadsheet with the formula in it.

    Many thanks,
    Adam
    Attached Files Attached Files

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Gantt Chart Formula Problem

    1) The initial formula would be:

    =MEDIAN($B3:$C3,E$2)=E$2

    or even better:

    =AND(COUNT($B3:$C3)=2,MEDIAN($B3:$C3,E$2)=E$2)

    2) You don't put this in the cell, you highlight all the cells you want to apply this to starting with E3, the simply create the CF rule using that formula above and the color of choice.
    Attached Files Attached Files
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  3. #3
    Forum Contributor
    Join Date
    07-22-2015
    Location
    San Francisco
    MS-Off Ver
    Mac 2011 Version 14.5.2
    Posts
    107

    Re: Gantt Chart Formula Problem

    Thanks so much for your help!! Much appreciated.

+ 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. Formatting problem - text okay, numbers invisible on Gantt chart
    By Ian99099 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-27-2016, 08:03 AM
  2. Replies: 5
    Last Post: 10-04-2012, 07:01 AM
  3. Replies: 0
    Last Post: 07-13-2012, 06:40 PM
  4. Gantt Chart problem - using time
    By jlink3 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-05-2012, 02:19 AM
  5. Gantt Chart Formula
    By Jon Excel in forum Excel General
    Replies: 1
    Last Post: 04-25-2011, 01:44 PM
  6. formula for gantt chart
    By sanlen in forum Excel General
    Replies: 1
    Last Post: 08-31-2010, 08:53 AM
  7. gantt chart problem
    By joe316 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-13-2007, 05:56 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