How to change the color of stoplight formats

You change the color of stoplight formats to change the default colors that categorize worksheet values as unacceptable, acceptable, and desirable. For example, you might want to change the color for the acceptable category from the default color (i.e. yellow) to blue. Discoverer applies colors that you specify to all existing and new stoplight formats in the current worksheet.

Note: To change the default stoplight colors for all stoplights in Discoverer Plus Relational, choose Tools | Options | Formats and select the Stoplight Color Format option.

To change the color of stoplight colors:

1. Open the workbook that contains the worksheet that you want to format.

2. Choose Format | Conditional Formats to display the "Conditional Formats dialog".

3. Click Edit Stoplight Colors to display the "Stoplight colors dialog".

   
   Description of the illustration d_cf6.gif
   
   

4. Change the color of the categories as required.

5. Click OK to save changes that you have made.

6. Click OK to close the Conditional Formats dialog.

   The worksheet is updated with the formatting changes that you have made.

Notes

• You can also edit stoplight colors in the following way:

  • Right-click on the worksheet data area, and select the Conditional Format option to display the "Conditional Formats dialog", and click Edit Stoplight Colors.