Microsoft Project – different colour rows depending on work type

I was asked by a client who works in the building industry how he could colour code rows on his Project plan according to work type. The work types were Electrical, Partitions, Decorating, Floors, Ceiling.

First we created a new column called Work Type. To do this, on the Project tab, in the Properties group, click Custom Fields.

Worktype1

We selected Text1, clicked Rename, named it as Work Type and clicked OK. We then clicked Lookup and typed in the relevant work types, then clicked Close, then OK.

Worktype2

We then right-clicked on the column heading to the right of where we wanted the Work Type column, clicked Insert Column and selected Text1 (Work Type).

Then, for each relevant task, the relevant work type was selected from the dropdown list.

It was the rows on the Entry table that he wanted formatted in different colours. To do this, we filtered by each Work Type in turn, and with the filter in place, selected those rows. Then from the Task tab, in the Font group, click the Background Color dropdown and select your required colour for that work type.

If different colours had been wanted for the bars, with the filter in place, and the rows selected, go to the Gantt Chart Tools Format tab, then in the Bar Styles group, click the Format dropdown, click Bar and make your colour choice from there.

Find out more about our Microsoft Project training London, Surrey, Middlesex or our Microsoft Project training Dorset, Hampshire, Wiltshire.

About jdonbavand

I am a trainer of Microsoft Office, Microsoft Project and Crystal Reports. I have called my blog "If Only I'd Known That...." because I hear it so many times in training sessions. In fact, if only I had a £100 (or 150 Aussie dollars)for every time someone says "If only I'd known that." ....
This entry was posted in Microsoft Project, Microsoft Project 2013, Microsoft Project 2016, Uncategorized and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s