Welcome to PMConnection

     

Menu
· 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 @ 13: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:

IIf(Weekday([Start],1)=1,”yes”,IIf(Weekday([Start],1)=7,”yes”,IIf(Weekday([Finish],1)=1,”yes”,IIf(Weekday([Finish],1)=7,”yes”,”No”))))


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:

Excellent
Very Good
Good
Regular
Bad


Options

 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.12 Seconds