Notes on using conditional formats and stoplight formats

When you use conditional formats and stoplight formats, note the following points:

• Conditional formats that you create in Discoverer Plus Relational are available in Discoverer Viewer and Discoverer portlets (i.e. created using Discoverer Portlet Provider). You can also change the thresholds for stoplight formats in Discoverer Viewer and Discoverer portlets. For example, in Discoverer Plus Relational you might create a stoplight format that displays profit increases of more than 25% as desirable (i.e. in green). When an end user accesses this worksheet in Discoverer Viewer, they can change the threshold for the desirable category from 25% to 30%.

• Conditional formats created in Discoverer Plus Relational are visible in Discoverer Desktop.

• You can create conditional formats on both numeric and non-numeric worksheet items (e.g. text worksheet items). For example, you can create a conditional format for Location = "New York", or Profit SUM > 30,000.

• You can only create stoplight formats on numeric worksheet items.

• Stoplight colors are applied to all stoplight formats in a worksheet. If you change the stoplight colors, Discoverer applies the changes to existing and new stoplight formats in the current worksheet (for more information, see "How to change the color of stoplight formats").