Tracking Project With Gantt Chart

Hi,

I want to use the gantt chart to track the progress of the construction project. I have many different building to be built. some of them might be started at the same time. some of them might finish at the same time or different time.

Can you please advice the idea of how to create this gantt chart in excel?

thanks

sanlen

It's really not very clear what you want ... always a good idea to outline (manually) your desired results - this helps prevents confusion/misinterpretation - issues with terminology.

The narrative above is confusing... I think you're saying if no error then blue else yellow ?

'Gantt Chart'!B3:
=AND('Main Data'!C3<TODAY(),ISNUMBER('Main Data'!C3))*(1+('Main Data'!$B3="Yes"))
copied across matrix B3:K13

2 rules for B3:K13

rule1: value = 1 - format blue
rule2: value = 2 - format yellow

Originally Posted by sanlen

Instead of the default background color (Grey), and after the status i change to Yes, i want the color for PROJECT 2 & PROJECT3 at MS03 to be changed to Yellow.

In which case

Please Login or Register  to view this content.

same rules as before ... ie one where value = 1 (blue) and another where value = 2 (yellow)

(the only difference in the above formula from before is that now only the last milestone on the project will be flagged yellow [where problem exists])

Hi,

i am trying the below formula for my gantt chart

=IF(AND('Main Data'!B3<>"",'Main Data'!B3<=TODAY(),ISNUMBER('Main Data'!B3)),"BULE",IF(AND('Main Data'!B3<>"",ISTEXT('Main Data'!B3)),"YELLOW"))

Condition 1:
Cell Value, equal to =B3="BLUE"

Condition 2:
Cell Value, equal to =B3="YELLOW"

However, when i applied this to Conditional Formatting it seems does not work.

Could you please advice?

post a file with the formulae and formatting in place

If you use "Value Is" rather than "Formula Is" approach to Conditional Formatting then the rules would be:

Cell ValueIs: Blue
rather than: =B2="Blue"

(same for Yellow)

If you use a Formula driven approach then use =B2="Blue"

You might also want to revise the formula in the sample to return Blue rather than Bule

You have the solution so there's little more I can do at this stage I'm afraid.

I would suggest deleting your existing rules and starting again - you may find it easier to install FormulaIs based rules with your existing logic.