View source for Conditional Formatting with Boolean Fields for OnePager Express for Version 6.1

==Overview==

The OnePager '''Conditional Formatting''' feature also supports Microsoft Excel '''Boolean''' fields which have only two values. That is, those fields whose values can be resolved to either a '''TRUE''' or a '''FALSE'''.    OnePager supports these four values (i.e., '''Yes''', '''No''', '''True''', or '''False''').

==Example==

1) As an example, suppose we have the Microsoft Excel '''source plan''' shown below which consists of three phases and resources consisting of four teams ('''Team 1''', '''Team 2''', '''Team 3''', and '''Team 4''').

<center>[[File:X61-11_6_1-61-(1)-10312017.png]]</center>
<!--center>X61-11_6_1-61-(1)-10312017.png</center-->

2) In the Microsoft Excel '''source plan''' above, the field titled '''Team Available''' is actually a '''Boolean''' field.

3) Creating a simple project view without '''Conditional Formatting rules''' produces something like this:

<center>[[File:X61-11_6_1-61-(3)-10312017.png]]</center>
<!--center>X61-11_6_1-61-(3)-10312017.png</center-->

4) Now suppose you want to represent any team that is '''Available''' regardless of the team name with a different task shape.  This can be done by creating the following '''Conditional Formatting rule''' by accessing the '''Template''' through the second page of the OnePager Choices ('''OPC''') form:

<center>[[File:X61-11_6_1-61-(4)-10312017.png]]</center>
<!--center>X61-11_6_1-61-(4)-10312017.png</center-->

5) When the '''Conditional Formatting Rules''' are in place and the project view is created it looks like this:

<center>[[File:X61-11_6_1-61-(5)-10312017.png]]</center>
<!--center>X61-11_6_1-61-(5)-10312017.png</center-->

6) OnePager applies the '''Conditional Formatting Rule''' created through the '''Conditional Formatting Rules''' form, adjusts the '''legend’s title''', and provides a '''legend item''' to reflect the rule applied.  You can manually change the '''legend title text''' and '''legend item text''' as required.

7) Should you later go back and change the '''Team Available''' field in the Microsoft Excel '''source plan''', the next OnePager '''snapshot''' reflects the change by continuing to apply the rule. 

:a) Suppose we want to put emphasis on '''Team 4''' in the next '''snapshot'''.  To do this it’s just a matter of changing the '''Team Available''' field in the Microsoft Excel '''source plan''' accordingly so it looks like this:

<center>[[File:X61-11_6_1-61-(6)-10312017.png]]</center>
<!--center>X61-11_6_1-61-(6)-10312017.png</center-->

:b) You can now create another '''snapshot''' with OnePager the normal way and the project view now looks like this: 

<center>[[File:X61-11_6_1-61-(7)-10312017.png]]</center>
<!--center>X61-11_6_1-61-(7)-10312017.png</center-->

:c) '''Note''' that the tasks with the new shape are all associated with '''Team 2 and Team 4''' and the legend is updated to reflect that '''Teams 2 and 4''' are using the desired shape.

(11.6.1-61)

[[Category:Version 6.1]]
[[Category:Project Views]]
[[Category:Conditional Formatting]]
[[Category:Templates]]
[[Category:Project-View Properties Form]]
[[Category:Editing a Project View]]
[[Category:Task/Milestone Editing]]
[[Category:Labels]]
[[Category:Color Palettes]]
[[Category:Row/Swimlane Borders]]
[[Category:Mavericks]]
[[Category:OnePager Express]]