Forum Discussion
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.
Hey Terry-
have you taken a look at this Gantt Planner Template yet? Will it do what you would like?
https://templates.office.com/en-us/Gantt-project-planner-TM02887601
- 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.
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.
Did you receive the example?
