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.
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?
Terry-
I have not received an example. Did you post it to this thread? I didn't see a Private Message either.
