Conditional formatting with Nested If Statement utilising Dates

[barkertri]

Hi All

I am trying to produce a Resource plan which shows projects in Column A, then has 5 Stages for each project which contain a Project start date then at lest 3 items of data (Stage Lead (Name), Stage Finish Date, and Stage Resource). I need to create something akin to a horizontal stacked bar chart for each project showing the different Stages with different colour conditional formating per stage and showing the stage number (which is a heading above the Stage Lead). I have posted an example of the first Stage below, the remainder of teh stage replicate this but have progressive timellines.
The issue i have is how do i get a formula to drive the conditional formating of an area which is headed by dates to give me a stacked bar chart kind of look?

Any Help would be greatly apreciated as my nested IF's are failing at the first hurdle...not even sure if this is the best formula to use and am opento any siggestions people may have?


Thanks in Advance

Barkertri

Data Sample
[TABLE="width: 525"]
<tbody>[TR]
[TD]Project
[/TD]
[TD]Resource Required
[/TD]
[TD]Project Start Date
[/TD]
[TD]No of Days
[/TD]
[TD]Stage 1
[/TD]
[TD]Stage 1 Finish Date
[/TD]
[TD]Stage 1 Resource
[/TD]
[/TR]
[TR]
[TD]Project 1
[/TD]
[TD]0.7
[/TD]
[TD]31/10/2013
[/TD]
[TD]60
[/TD]
[TD]SB1
[/TD]
[TD]03/11/2013
[/TD]
[TD]0.04
[/TD]
[/TR]
[TR]
[TD]Project 2
[/TD]
[TD]1.15
[/TD]
[TD]04/11/2013
[/TD]
[TD]60
[/TD]
[TD]SB2
[/TD]
[TD]07/11/2013
[/TD]
[TD]0.07
[/TD]
[/TR]
[TR]
[TD]Project 3
[/TD]
[TD]0.85
[/TD]
[TD]02/12/2013
[/TD]
[TD]60
[/TD]
[TD]SB3
[/TD]
[TD]05/12/2013
[/TD]
[TD]0.05
[/TD]
[/TR]
[TR]
[TD]Project 4
[/TD]
[TD]0.85
[/TD]
[TD]09/11/2013
[/TD]
[TD]60
[/TD]
[TD]SB3
[/TD]
[TD]12/11/2013
[/TD]
[TD]0.05
[/TD]
[/TR]
[TR]
[TD]Project 5
[/TD]
[TD]0.7
[/TD]
[TD]14/11/2013
[/TD]
[TD]60
[/TD]
[TD]SB2
[/TD]
[TD]17/11/2013
[/TD]
[TD]0.04
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Jerry Sullivan]

Hi Dave,

This thread has an explanation of one way to make a Gantt Chart using Conditional Formatting.
http://www.mrexcel.com/forum/excel-...-based-meeting-2-criteria-need-help-asap.html

 

[barkertri]

Thanks Jerry

Got a new question now...will post a new thread

BR

Dave