Hi Guys, I had previously asked this question in the General forum but i think its more relevant here 
Firstly I want to appreciate the efforts put into the blog by Chandoo.org team and it’s a great place to learn excel and use it within our company roles. Coming to my question I have took inspiration from Chandoo’s template for project management gantt chart(Thanks!). I have made some tailored changes for my purpose. You can find the file at http://speedy.sh/nrzqr/Project-gannt-dummy.xlsx
1. Basically, I have 2 projects running in a flow (Column B). . And online one Project can be worked on at one machine (column C). What I was looking at is identifying machine conflicts. Looking up machine and its date for the above project and highlighting if its similar. ( example – Cell C102)
2. My second question based on the machines and dates is is there a way to produce gannt chart I have given an example in tab – “Machine Gannt”.
I looked through the excel challenge -
http://chandoo.org/wp/2011/03/09/ec1-machine-scheduling-in-excel/ .. but the formulas dont seem to be working for this sheet.
I highly appreciate your help !!
Thanks in advance!
Firstly I want to appreciate the efforts put into the blog by Chandoo.org team and it’s a great place to learn excel and use it within our company roles. Coming to my question I have took inspiration from Chandoo’s template for project management gantt chart(Thanks!). I have made some tailored changes for my purpose. You can find the file at http://speedy.sh/nrzqr/Project-gannt-dummy.xlsx
1. Basically, I have 2 projects running in a flow (Column B). . And online one Project can be worked on at one machine (column C). What I was looking at is identifying machine conflicts. Looking up machine and its date for the above project and highlighting if its similar. ( example – Cell C102)
2. My second question based on the machines and dates is is there a way to produce gannt chart I have given an example in tab – “Machine Gannt”.
I looked through the excel challenge -
http://chandoo.org/wp/2011/03/09/ec1-machine-scheduling-in-excel/ .. but the formulas dont seem to be working for this sheet.
I highly appreciate your help !!
Thanks in advance!