OnePager Pro timeline software gives you the ability to create conditional formatting rules so that your Microsoft Project plan can be formatted just as easily as an Excel spreadsheet. You can download a free trial of OnePager Pro and follow along with the steps below to see how it works:
- Start with a Microsoft Project file:
If you only want to show certain tasks or milestones, put a "Yes" next to them in the "Flag 20" column before launching OnePager Pro.
- Double-click the OnePager Pro icon on your desktop. From the Start screen that appears, choose New.
- Choose your Microsoft Project plan as the source file for your OnePager Gantt chart.
- When the import wizard (below) appears, give your report a name and a status/snapshot date:
- Click the Create new project view button to create your initial OnePager Pro report:
This initial view looks better than Microsoft Project, but doesn't have a lot of formatting yet. It's a good starting point for the rules we'll create in the next few steps.
- To begin setting up conditional formatting rules, click on the Home tab and on the Project View Properties button:
- Now, go to the Task Bars tab, and click on the Manage Rules button at the bottom of the form:
- This will launch the conditional formatting rules editor. In this example, we'll set up four rules to dynamically define the shape and color of each task based on the value of the "Resource Names" column in Microsoft Project:
You can create as many conditional formatting rules as you'd like, and you can use any Microsoft Project data to define the rules. So, if you want to drive your shape by "Resource Names" and your color by "Status", you can. OnePager Pro's conditional formatting rules are very flexible.
- Clicking OK twice will return you to your OnePager Pro chart, which will automatically be updated based on the rules you just defined:
- If you like the way your chart looks, just click the Copy Graph button on the Home tab, and paste your chart into PowerPoint or e-mail to share with others on your team.
OnePager Pro is the only application that lets you apply conditional formatting rules to an existing Microsoft Project plan without having to export data to Excel or redraw a Gantt chart by hand in PowerPoint. OnePager Pro reports look great, and save you tons of time because they're so easy to create!15-Day