Simple gantt chart question

[harcsakutya]

Hi,

Thank you for your gantt chart, I like it.
http://chandoo.org/wp/2014/02/18/quick-gantt-chart-excel-template/

I’d like to ad another function but don’t know how.

If create a column called „Duration by value” in your worksheet, when I enter a value one of the cell in row, number of cells has to be colored based on cell value.

Thank you in advance,

 

[eibi]

Welcome to the forums!

It is a little difficult to understand your request; see attached -- perhaps this is what you want?

If you have something different in mind, may I suggest that you manually create the outcome you want to see, and then we'll see if we can mimic that outcome with some kind of automation.

All best!

 

[harcsakutya]

Hi eibi
Thank you for your prompt reply,
I enclosed that I like to accomplish:
https://drive.google.com/file/d/0B9KaCF56CJ3QSU9qcVlqMTlRX0k/view?usp=sharing

Thanks

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[eibi]

I've modified the conditional formatting in your original file accordingly...See attached.

 

[harcsakutya]

Thank you Mr. Narayan and eibi, this exactly that I wanted!