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

Conditional Formatting Example

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


Example of Conditional Formatting Drop-Down List Box

Select Expense, and then click Format Cells button to apply bold formatting to the selected cell. (Leave all other font properties unchanged.)


Example of Comparison Options Drop-Down List Box

Format Cells dialog box with the font set to bold

Click Add Condition 2 buttonto add a second condition. Set the Condition 2: If statement to Current Cell Value. Set the operator value to > (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 condition, and then click Format Cells button to set the background color to green when a Cola cell has a value < 1000.


Example of Adding a New Format

Format Cells dialog box with background color set to green

After you establish the conditions, you can select the check box for Allow Parentheses.

In the following scenario:

Condition 1 and Condition 3
or
Condition 2 and Condition 3

If a cell has the label Cola associated with it and the cell value < 1000, the background is set to green. If a Member Name contains Cola and the cell value is < 1000, the background is set to green.