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.

  • Unacceptable

    Use this field to enter the threshold for the unacceptable category. For example, enter 5000 to make the unacceptable threshold 5000 or less.

  • Acceptable

    This read-only field is populated automatically based on the values that you enter in the Unacceptable and Desirable fields.

  • Desirable

    Use this field to enter the threshold for the desirable category. For example, enter 30000 to make the desirable threshold 30000 or more.

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.