What’s new in OnePager Pro 5.0 (Part 5/6)

Conditional Formatting

Conditional formatting is perhaps the most powerful feature in OnePager Pro 5.0. Why? Because conditional formatting lets you drive marker shape, color, borders, font, and height with data from your Microsoft Project Plan, and automatically update these attributes as your plan changes. With OnePager Pro 5.0, you can set up conditional formatting rules that look like this:

These rules will automatically be applied to the tasks and milestones in your OnePager Pro chart based on the data that you already have in Microsoft Project.

The simple Microsoft Project plan below has some sample data that will be picked up by the conditional formatting rules. Notice that initially, all tasks are marked as “Low Risk”:

When the project view is first created, all three low risk tasks are formatted with a green color according to the conditional formatting rules:

Now, let’s update the project plan, adjusting the risk of two of the tasks:

When we refresh the OnePager Pro chart, the conditional formatting rules are automatically reapplied, and the tasks change the formatting automatically based on the changes in Microsoft Project:

The example above is pretty simple, but it illustrates the power of conditional formatting. Think about how much time you would spend making PowerPoint slides showing this information. With conditional formatting, you can create Gantt Art instead of Gantt charts!

Our final post will cover a useful enhancement to OnePager Pro 5.0 that allows for better management of projects with complex resource assignments.

This entry was posted in Gantt Art, OnePager 5.0, Project Reporting, Project Visualization and tagged by Bob. Bookmark the permalink.

About Bob

Bob is a seasoned technology and project management executive. As an Air Force Officer (Colonel) from 1965 through 1991, he served in a number of executive leadership, computer system development, and program management roles. After retirement, he joined Robbins-Gioia, Inc. as a Regional Vice President and Program Management Consultant. He then moved to state government, where he held numerous influential positions, culminating in his service as Chief Information Officer for the State of Colorado under Governor Bill Owens. Bob has a doctorate degree in Operations Research and an MBA from Indiana University, and a bachelor’s degree from the University of Miami.

Leave a Reply

Your email address will not be published. Required fields are marked *