Tracking Project With Gantt Chart

**sanlen** · 08-20-2010, 04:31 AM

Hi,

I am thinking of using 3 different colors on the sheet. Grey: the default background color that i just changed. Blue: the color for those milestone completed, Yellow: milestone that are having problems and make project cannot be continued and waiting the solution.

i.e: while we in the middle of MS03 of PROJECT2 & PROJECT3 then we suddenly having problems and PROJECT2 & PROJECT3 need to be halted. So i will go to PROJECT PROBLEMS in Main Data sheet and manually change the status to Yes.

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.

thanks you very much for your time.

**DonkeyOte** · 08-20-2010, 04:38 AM

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

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

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])

Tracking Project With Gantt Chart

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Tracking Project With Gantt Chart

Re: Tracking Project With Gantt Chart

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions