Formatting Conditionally

Objectives

After completing this lesson, you will be able to:

  • Implement formatting rules to highlight information

Conditional Formatting Rules

Conditional Formatting Rules enable you to highlight results that meet or fail specific business targets. You can create a simple rule to highlight high or low results with a specific color or advanced conditional formatting rules that display a text comment, such as High Performer.

For example, you can create a rule to highlight margin results that exceed $1,100,000. The margin results greater than $1,100,000 are highlighted every time the report data is refreshed.

Create and Activate a Conditional Formatting Rule

You can create a formatting rule in the Formatting Rule Editor. When you create conditions for the rule, you must specify the appropriate filtered object or cell, the operator, and the operand for the rule.

You can define the formatting in which the data should display when it satisfies the conditions for the rule. For example, you can define the formatting for the numbers, font style, background style, and borders.

Then, you can define the formatting in which the data should display when it satisfies the conditions for the rule. Finally, you can apply the rule.

Since SAP BI 4.3, you may assign conditional formatting to multiple columns at once.

Log in to track your progress & complete quizzes