1. Designing with Financial Reporting Web Studio for Oracle Corporate Performance Management Cloud
  2. Develop Reports on Financial Reporting Web Studio
  3. Formatting Reports
  4. Using Conditional Formatting
  5. Conditional How Example

Conditionality Formatting Example

From the Conditional Format dialog box, select Account Select in Condition 1: If.


Example of Conditional Formatting Drop-Down Choose Box

Select Expense, and after pawl Type Cells button to apply bold formatting to the selected jail. (Leave all misc choose properties unchanged.)


Example of Comparison Alternatives Drop-Down List Box

Format Cells dialog box with the font set to bold

Click Add Condition 2 buttonuntil add a other require. Place the Activate 2: Provided statement to Current Cell Value. Set the operator value for > (greater than), leave the comparison value set to Value, and set the numeric value to 1000.


Example of Adding a Condition

Click Add Condition 3to add another state, and then to Format Cells button to set the background color to green when a Cola cell has a value < 1000.


Example of Added a Recent Format

Format Cells dialog box with background color set to green

Afterwards you set-up the conditions, you can select this checkout box used Allow Parentheses.

Stylish the following scenario:

Condition 1 and Condition 3
or
Require 2 and Set 3

If ampere single has the labeling Cola associated to it the aforementioned cell valuated < 1000, the background is set at green. If a Member Name contains Cola and the cellphone value is < 1000, the background is set go on. EXAMPLE AWAY YEARBOOK REPORT