My VBA is pretty hopeless but I find that so much can be achieved without it that I never need it.Įxhaust the possible simple solutions before over-reaching to the complicated ones.Note: To access the Gantt Chart view, on the View menu, click Gantt Chart. Once you get the hang of using the spare custom fields you can also sort, filter and group on them, so they become really important. When you make or contemplate serious formatting changes like this it is best to make it part of a new View rather than messing up the built in View. You could set Flag1 by data input or you could make it a calculated result with a formula.

You could use this to make all normal tasks which also have Flag1 set to 'Yes' take on whatever style you choose. If you use one of the custom fields such as Flag1 you could use a combination criteria such as 'Normal, Flag1'. You have to get the syntax right with the comma etc. Another good one is 'Milestone, Critical', which can be used to make zero total slack Milestones go red. This one makes Summary bars which have zero Total Slack go whatever colour you like. Some of the criteria can be combinations, eg 'Summary,Critical'. Have a look at some of the formatting in some of the built in Views for clues about how to set bar styles colours for Tasks that meet certain criteria. Is this possible? Am I overly complicating an easy task?Īpologies if there is a simpler way round this, however my knowledge is fairly limited! Any help would be greatly appreciated. I would then look to create a macro that would search the 'Group name' column and then change the colour of the bar dependent upon the value in the cell eg red for 'retail', blue for 'supply chain' etc. The cell contents will then be the name of the group eg 'Retail','Supply Chain' etc. Im fairly new to Project and the only way I can think to achieve this so far is to create a column called 'Group name' with field name set to 'Text1'. I would also like their corresponding bar on the gantt chart to be a particular colour dependent upon what group that task is in. Tasks representing a certain business area are listed first followed by tasks representing a different business area underneath. I would like to be able to group together similar tasks ie. Im currently trying to put together a Gantt chart in MS Project.

Ms project gantt chart labels