Need help fast in conditional formatting...

[BusyPM]

For a seasoned Excel user this maybe a stupid question, however I am having a really hard time trying to figure out this formula...

I have built a spreadsheet for resource allocation. I have a list of start dates, and end dates of projects, then a list of two years worth of days along the top. What I need to know is how I can have the cells automatically become colored for the specific dates, just as you would see in the tasks of a gantt chart.

I have attached an example of what I'm trying to achieve.

Any help would be greatly appreciated!

Thank you!

 

[Somendra Misra]

Hi,

Since your sample file is missing, you can go through the articles on below page.

http://chandoo.org/wp/tag/gantt-charts/

As far as different colour for different project is concerned, if there are 4 projects than this can be handled by CF by say for different rules, but if the projects are many than I think VBA will be a better option.

Regards,

 

[Syedali]

PFA , I have putted "formula" in conditional formatting. Kindly let me know if you have any clarification.