Building a visual program for development work - Formula tips?

[samtron]

Hi all, just after some help with formula's. I'm attempting to create a visual work schedule (like a time line) for constuction/development work. I have start and end dates and would like cells to 'fill' according to the dates filled out in the same excel document. Once I've established the basic step, I'd like to use different colours for different trigger points.

Your help would be much appreciated

S

[samtron]

Apparently a Gantt chart would be the best way to build this, anyone have much experience with Gant Charts?