Skip Headers
Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Discoverer Plus
11g Release 1 (11.1.1)

Part Number B40105-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF

New Stoplight Format dialog

Use this dialog to create a stoplight format for a worksheet item. For example, you might want to categorize sales figures as unacceptable, acceptable, and desirable.

This dialog is also displayed as:
Edit Stoplight format dialog

For more information, see:

"About managing conditional formatting"

"What is a stoplight format?"

"Examples of conditional formatting"

Note: You can only have one active conditional format or stoplight format for each numeric worksheet item. For example, to activate a stoplight format on a worksheet item that has a active stoplight format, you must first deactivate (or delete) the existing stoplight format for that worksheet item.

What would you like to name your stoplight format?

Use this field to specify a short name for the stoplight format. The name you specify is used to identify the conditional format on other dialogs. If you want Discoverer to create a name for you, select the Generate Name Automatically check box.

Which data point would you like to format?

Use this drop down list to specify which worksheet item you want to apply the stoplight format to.

What are the thresholds for unacceptable and desirable data ranges?

Use these fields to specify the ranges for the unacceptable and desirable categories.

Edit Colors

Use this button to display the "Stoplight colors dialog", which enables you to change the color of unacceptable, acceptable, and desirable values.

Hide data values for stoplight formats

Use this check box to specify whether to display worksheet values for the worksheet item that is being formatted. For example, you might select this check box to create a more visual worksheet that displays formatting colors but not the values themselves.