Conditional Formatting Rules and the Legend for OnePager Live Beta 2 (MS Project Source)

From OnePager Documentation
Jump to: navigation, search


11.11.1-OPL2 from 11.11.1-60 7/14/2017

Because Conditional Formatting Rules can become complex, OnePager provides a means to show in the legend item text what rules set various colors and shapes. You can subsequently decide to change the legend-item text.


1) Suppose you have the Microsoft Project source plan shown below where the Text20 field is used to represent the project’s phases. Highlighted below are four tasks of which three are in Phase THREE and one is in Phase END. You would like to represent these four tasks in black with a left pointing arrow symbol. First, let’s see the Microsoft Project source plan:

P52-11 11-(1)-06022015.png

2) When you create the basic project view with round-robin color assigned from Phase (Text20), it will look like this:

P52-11 11-(2)-06022015.png

3) To implement the desired results for tasks in Phases THREE and END, you might create conditional formatting rules that look like this:

P60-11 11 1-60-(3)-02142017.png

4) When the project view is created, the highest priority rule shown above will be applied, and the four tasks highlighted in the Microsoft Project source plan will have these rules applied. Thus, tasks I, J, K, L, and Q will show the results of applying the highest priority conditional formatting rule as shown here:

P52-11 11-(4)-06022015.png

5) Notice that the legend entry for Phase THREE shows that the Not O conditional formatting rule was applied to the tasks that have the black reverse arrow tasks.