Difference between revisions of "Conditional Formatting for Version 7.0 (Portal)"

From OnePager Documentation
Jump to: navigation, search
Line 1: Line 1:
 
==About Conditional Formatting==
 
==About Conditional Formatting==
  
'''Conditional formatting''' allows you to define a '''set of rules''' that alter the look of your chart as the data in your Microsoft Project '''source plan''' or Microsoft Excel '''source plan''' changes. It goes beyond the '''dynamic color-coding''' feature described in the article at: [[Task Bars Tab for Version 7.0 (OnePager Pro) | Task Bars Tab-OnePager Pro]].  21.1.3.1-70
+
'''Conditional formatting''' allows you to define a '''set of rules''' that alter the look of your chart as the data in your Microsoft Project '''source plan''' or Microsoft Excel '''source plan''' changes.  
 +
 
 +
It goes beyond the '''dynamic color-coding''' feature described in the article at: [[Task Bars Tab for Version 7.0 (OnePager Pro) | Task Bars Tab-OnePager Pro]].  <!--21.1.3.1-70
  
 
The following elements can be defined by using '''conditional formatting''' rules:
 
The following elements can be defined by using '''conditional formatting''' rules:
Line 11: Line 13:
 
:* '''Label Font'''
 
:* '''Label Font'''
  
To go directly to the list of detailed articles for '''Conditional Formatting''' for OnePager Pro and Express, click here: [[Conditional Formatting for Version 7.0 (Portal)#Related Links | Conditional Formatting - Related Links]] 11.0.1-70
+
To go directly to the list of detailed articles for '''Conditional Formatting''' for OnePager Pro and Express, click here: [[Conditional Formatting for Version 7.0 (Portal)#Related Links | Conditional Formatting - Related Links]] <!--11.0.1-70-->
  
 
==Conditional Formatting Controls==
 
==Conditional Formatting Controls==
Line 18: Line 20:
  
 
<center>[[File:P70-11_0_1-(1)-06052020.png]]</center>
 
<center>[[File:P70-11_0_1-(1)-06052020.png]]</center>
<center>P70-11_0_1-(1)-06052020.png</center>  
+
<!--<center>P70-11_0_1-(1)-06052020.png</center>-->
 +
 
 +
Clicking the '''Manage Rules...''' button in this control group accesses the  '''Conditional Formatting Rules''' form where you can '''add''', '''edit''', and '''delete conditional formatting rules'''.
  
Clicking the '''Manage Rules...''' button in this control group accesses the  '''Conditional Formatting Rules''' form where you can '''add''', '''edit''', and '''delete conditional formatting rules'''. Detailed articles are provided to assist you with using the '''Conditional Formatting''' feature for both OnePager Pro and Express below:  [[Conditional Formatting for Version 7.0 (Portal)#Related Links | Related Links)]] 11.0.1-70
+
Detailed articles are provided to assist you with using the '''Conditional Formatting''' feature for both OnePager Pro and Express below:  [[Conditional Formatting for Version 7.0 (Portal)#Related Links | Related Links]] <!--11.0.1-70-->
  
 
The same '''Conditional Formatting''' control group is available in the OnePager Pro '''Chart Properties''' form as well as the '''Template''' form and '''Chart Properties''' form for OnePager Express.
 
The same '''Conditional Formatting''' control group is available in the OnePager Pro '''Chart Properties''' form as well as the '''Template''' form and '''Chart Properties''' form for OnePager Express.
Line 29: Line 33:
  
 
<center>[[File:P70-11_0_1-(2)-06052020.png]]</center>
 
<center>[[File:P70-11_0_1-(2)-06052020.png]]</center>
<center>P70-11_0_1-(2)-06052020.png</center>  
+
<!--<center>P70-11_0_1-(2)-06052020.png</center>-->  
  
 
To achieve this result in the chart, below is the simple set of '''Conditional Formatting Rules''' used:
 
To achieve this result in the chart, below is the simple set of '''Conditional Formatting Rules''' used:
  
 
<center>[[File:P70-11_0_1-(3)-06052020.png]]</center>
 
<center>[[File:P70-11_0_1-(3)-06052020.png]]</center>
<center>P70-11_0_1-(3)-06052020.png</center>
+
<!--<center>P70-11_0_1-(3)-06052020.png</center>-->
  
 
==Related Links==
 
==Related Links==
  
 
{| class="wikitable"
 
{| class="wikitable"
| [[Conditional Formatting Overview for OnePager Pro for Version 7.0 | Conditional Formatting Overview-OnePager Pro]] 11.1.1-70
+
| [[Conditional Formatting Overview for OnePager Pro for Version 7.0 | Conditional Formatting Overview-OnePager Pro]] <!--11.1.1-70-->
| [[Conditional Formatting Overview for OnePager Express for Version 7.0 | Conditional Formatting Overview-OnePager Express]] 11.2.1-70
+
| [[Conditional Formatting Overview for OnePager Express for Version 7.0 | Conditional Formatting Overview-OnePager Express]] <!--11.2.1-70-->
 
|-
 
|-
| [[Adding Conditional Formatting Rules for OnePager Pro for Version 7.0 | Adding Conditional Formatting Rules-OnePager Pro]] 11.3.1-70
+
| [[Adding Conditional Formatting Rules for OnePager Pro for Version 7.0 | Adding Conditional Formatting Rules-OnePager Pro]] <!--11.3.1-70-->
| [[Adding  Conditional Formatting Rules for OnePager Express for Version 7.0 | Adding  Conditional Formatting Rules-OnePager Express]] 11.4.1-70
+
| [[Adding  Conditional Formatting Rules for OnePager Express for Version 7.0 | Adding  Conditional Formatting Rules-OnePager Express]] <!--11.4.1-70-->
 
|-
 
|-
| [[Conditional Formatting with Boolean Fields for OnePager Pro for Version 7.0 | Conditional Formatting with Boolean Fields for OnePager Pro]] 11.5.1-70
+
| [[Conditional Formatting with Boolean Fields for OnePager Pro for Version 7.0 | Conditional Formatting with Boolean Fields for OnePager Pro]] <!--11.5.1-70-->
| [[Conditional Formatting with Boolean Fields for OnePager Express for Version 7.0 | Conditional Formatting with Boolean Fields for OnePager Express]] 11.6.1-70
+
| [[Conditional Formatting with Boolean Fields for OnePager Express for Version 7.0 | Conditional Formatting with Boolean Fields for OnePager Express]] <!--11.6.1-70-->
 
|-
 
|-
| [[Managing Conditional Formatting Rules for OnePager Pro for Version 7.0 | Managing Conditional Formatting Rules for OnePager Pro]] 11.9.1-70
+
| [[Managing Conditional Formatting Rules for OnePager Pro for Version 7.0 | Managing Conditional Formatting Rules for OnePager Pro]] <!--11.9.1-70-->
| [[Managing Conditional Formatting Rules for OnePager Express for Version 7.0 | Managing Conditional Formatting Rules for OnePager Express]] 11.10.1-70
+
| [[Managing Conditional Formatting Rules for OnePager Express for Version 7.0 | Managing Conditional Formatting Rules for OnePager Express]] <!--11.10.1-70-->
 
|-
 
|-
| [[Conditional Formatting Rules and the Legend for OnePager Pro for Version 7.0 | Conditional Formatting Rules and the Legend for OnePager Pro]] 11.11.1-70
+
| [[Conditional Formatting Rules and the Legend for OnePager Pro for Version 7.0 | Conditional Formatting Rules and the Legend for OnePager Pro]] <!--11.11.1-70-->
| [[Conditional Formatting Rules and the Legend for OnePager Express for Version 7.0 | Conditional Formatting Rules and the Legend for OnePager Express]] 11.12.1-70
+
| [[Conditional Formatting Rules and the Legend for OnePager Express for Version 7.0 | Conditional Formatting Rules and the Legend for OnePager Express]] <!--11.12.1-70-->
 
|-
 
|-
| [[Conditional Formatting Rules and the Template for OnePager Pro for Version 7.0 | Conditional Formatting Rules and the Template for OnePager Pro]] 11.13.1-70
+
| [[Conditional Formatting Rules and the Template for OnePager Pro for Version 7.0 | Conditional Formatting Rules and the Template for OnePager Pro]] <!--11.13.1-70-->
| [[Conditional Formatting Rules and the Template for OnePager Express for Version 7.0 | Conditional Formatting Rules and the Template for OnePager Express]] 11.14.1-70
+
| [[Conditional Formatting Rules and the Template for OnePager Express for Version 7.0 | Conditional Formatting Rules and the Template for OnePager Express]] <!--11.14.1-70-->
 
|-
 
|-
| [[Conditional Formatting Actions for OnePager Pro for Version 7.0 | Summary of Conditional Formatting Actions-OnePager Pro]] 11.7.1-70
+
| [[Conditional Formatting Actions for OnePager Pro for Version 7.0 | Summary of Conditional Formatting Actions-OnePager Pro]] <!--11.7.1-70-->
| [[Conditional Formatting Actions for OnePager Express for Version 7.0 | Summary of Conditional Formatting Actions-OnePager Express]] 11.8.1-70
+
| [[Conditional Formatting Actions for OnePager Express for Version 7.0 | Summary of Conditional Formatting Actions-OnePager Express]] <!--11.8.1-70-->
 
|}
 
|}
  

Revision as of 20:42, 13 January 2021

About Conditional Formatting

Conditional formatting allows you to define a set of rules that alter the look of your chart as the data in your Microsoft Project source plan or Microsoft Excel source plan changes.

It goes beyond the dynamic color-coding feature described in the article at: Task Bars Tab-OnePager Pro.

Conditional Formatting Controls

You can define conditional formatting rules either before or after you create new chart. To create rules before you create a chart, use the Template Properties form by navigating to the Task Bars or Milestones tab and navigating to the Conditional Formatting control group as shown below in the OnePager Pro Template Properties form:

P70-11 0 1-(1)-06052020.png

Clicking the Manage Rules... button in this control group accesses the Conditional Formatting Rules form where you can add, edit, and delete conditional formatting rules.

Detailed articles are provided to assist you with using the Conditional Formatting feature for both OnePager Pro and Express below: Related Links

The same Conditional Formatting control group is available in the OnePager Pro Chart Properties form as well as the Template form and Chart Properties form for OnePager Express.

Conditional Formatting Example

As an example, the following chart, used throughout this Wiki, is shown below with the application of Conditional Formatting rules to vary the shapes used for tasks to indicate the Resource Name associated with each task shape shown.

P70-11 0 1-(2)-06052020.png

To achieve this result in the chart, below is the simple set of Conditional Formatting Rules used:

P70-11 0 1-(3)-06052020.png

Related Links

Conditional Formatting Overview-OnePager Pro Conditional Formatting Overview-OnePager Express
Adding Conditional Formatting Rules-OnePager Pro Adding Conditional Formatting Rules-OnePager Express
Conditional Formatting with Boolean Fields for OnePager Pro Conditional Formatting with Boolean Fields for OnePager Express
Managing Conditional Formatting Rules for OnePager Pro Managing Conditional Formatting Rules for OnePager Express
Conditional Formatting Rules and the Legend for OnePager Pro Conditional Formatting Rules and the Legend for OnePager Express
Conditional Formatting Rules and the Template for OnePager Pro Conditional Formatting Rules and the Template for OnePager Express
Summary of Conditional Formatting Actions-OnePager Pro Summary of Conditional Formatting Actions-OnePager Express

Other Resources

Conditional Formatting Tutorial Video

Blog-Display Certainty in Your Plan by Using Conditional Formatting

Using Microsoft Project Flag Fields with OnePager Pro's Conditional Formatting Rules

(11.0.1-70)