What Can I Do With Conditional Formatting?
With conditional formatting, you apply rules to your data to highlight when something important happens. For example, you might want to show when revenues meet high, medium, and low thresholds.
You can make conditional formatting rules available to one or multiple visualizations in a workbook.
Conditional formatting provides a way for the user to see events or changes in their data driven rules. For example, if you want to see when sales fall below a threshold, the user would write a rule that says when sales are below 500K, format the data points using the color red.
In each canvas, you can:
- Choose which rules to apply to the data in the canvas.
- Apply multiple rules to a canvas at the same time.
- Apply multiple rules to a measure at the same time.
- Change the order in which rules are applied.
- Turn rules on and off for a visualization.
Conditional formatting compares measures, such as revenue for a year, the number of units of a product, the number of students that didn't return to school during an academic year, with one of the following:
- A set of thresholds.
For example, highlight values in red if my blood pressure is above 90 or under 70.
- A target or goal.
For example, highlight values in red if my costs exceed my budget.
- A percentage of a target.
For example, highlight values in green when I reach 80% of my sales goal.
- A complex expression.
For example, highlight values in green when I achieve 5% growth in sales compared to the same period last year.
You can format:
- Fill color and color density.
- Font, font size, font color, and font style.
You can also:
- Add tooltips and legends.
- Deploy conditional formatting in the Oracle Analytics app.
Last Published Friday, December 8, 2023