Forum Discussion

Terry Gillespie's avatar
Terry Gillespie
Copper Contributor
Jun 06, 2018

gantt Excel formula Help

I am looking for a formula that can take a start date and end date to calculate percentage then add a color to the grid below the date.
Formulas & Functions
Need Help
Terry Gillespie's avatar
Terry Gillespie
Copper Contributor
Jun 06, 2018
I did and this is the type of thing I am looking for, however I need the formula to incorporate it into a project sheet that is already being used. I cant seem to acquire the formulas to help me get on the right track. Thank you for your help.
Matt Mickle's avatar
Matt Mickle
Bronze Contributor
Jun 06, 2018

Terry-

 

Would it be possible for you to provide a non-sensitive example file to help me under stand the structure of your data?  A simple Before and After example may help as well.  If I understand correctly you want to use conditional formatting to color in the cells based on a start and end date?

 

If you can't provide a file maybe a few screenshots would suffice?

 

Coincidentally, I found this template several years ago and had to modify it to get the result I needed.  I think I have a pretty good idea of what you would like to see. An example will make testing your specific scenario a bit easier.

 

 

  • Terry Gillespie's avatar
    Terry Gillespie
    Copper Contributor
    Jun 07, 2018

    Did you receive the example?

    • Matt Mickle's avatar
      Matt Mickle
      Bronze Contributor
      Jun 07, 2018

      Terry-

       

      I have not received an example.  Did you post it to this thread?  I didn't see a Private Message either.

Resources