Welcome to PMConnection


· Home
· The Project Management Search Engine
· Exclusive Articles

Related Sites

Related Books 1
Agile Practice Guide from PMI  

A Guide to the Project Management Body of Knowledge: PMBOK 5th Edition 2013

PMP Exam Prep: Rita's Course
Microsoft Project 2016 for Dummies


Microsoft Project 2016

The Ultimate Application Administrators Guide for Project Online

MS Project: How to Highlight Tasks that Start or Finish on the Weekend
Posted on Sunday, October 05 @ 12:52:09 CDT by webadmin

PMConnection Articles

How to Highlight Tasks that Start or Finish on the Weekend

This solution involves a Flag field, a formula, a Macro and the out of the box Marked Tasks field.

What you will end with is a schedule in which you can easily see or filter for Weekend Tasks:

Step 1 – Add the Formula

Insert “Flag3″ into your Gantt Chart view, then right click on the column heading and select Custom fields. Click on Rename and input “Weekend Task?”:

Click on >OK, then click on >Formula. Paste this formula into that box:


Click on >OK

Microsoft Project will alert you that any existing data in this field will be deleted. Click on >OK and >OK again.

You now have a field that displays a Yes if that task either Starts or Finishes on a Saturday and/or Sunday:

You could now use the auto-filter on the column heading and filter for just the “Yes” value. Perhaps this is enough. But we promised to Highlight these tasks. On to Step 2:

Step 2 – Highlight the Tasks

To do this, we are going to leverage the out of the box field called Marked Tasks and the Text Styles option.

Click on >Format, >Text Styles, for Item to Change, select >Marked Tasks, for Color change to Maroon, click on >OK:

Step 3 – Making it Work

In order to get the Weekend Tasks to display with Maroon text, we must leverage a macro. I used this code:

I created the macro so it would run with the key strokes of >Ctrl and e:

So now, after adjusting the schedule, I only need to hold down on the “Ctrl” key and hit “e” and my Weekend Tasks are highlighted in Maroon:

Note: You might find this book helpful:

Related Links
· More about PMConnection Articles
· News by webadmin

Most read story about PMConnection Articles:
300 Project Manager Interview Questions

Article Rating
Average Score: 0
Votes: 0

Please take a second and vote for this article:

Very Good


 Printer Friendly Printer Friendly

Associated Topics

PMConnection Articles

Sorry, Comments are not available for this article.

Copyright 2005-2017 PMConnection.com. All Rights Reserved.
http://www.pmconnection.com a
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.
Page Generation: 0.06 Seconds