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.