Conditional Formats (Table/Crosstab) page

Use this page to manage the conditional formats and stoplight formats that you apply to a worksheet. For example, you might want to activate a conditional format that highlights costs that are greater than 100,000.

For more information, see:

"Format Worksheet data links page"

"Create Conditional Cell Format page"

"Create Conditional Header Format page"

"Create Stoplight Format page"

Use these lists to create, manage and edit conditional and stoplight formats.

Hint: Use the check box in the Display column to activate and deactivate a format.

Note: You can have conditional formats and stoplight formats active on the same worksheet item at the same time.

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 if you want to create a worksheet that displays formatting colors but not the values themselves.

Create Stoplight Format

Use this button to display the "Create Stoplight Format page", which enables you to create a new stoplight format to categorize worksheet numeric values into acceptable, desirable, and unacceptable categories.

Create Conditional Cell Format

Use this button to display the "Create Conditional Cell Format page", which enables you to create a new conditional format to highlight worksheet numeric values.

Create Conditional Header Format

Use this button to display the "Create Conditional Header Format page", which enables you to create a new conditional format to highlight worksheet header values.

Display

Use these check boxes to display the conditional format in the current worksheet.

Note: If more than one Display check box is selected (e.g. when there are multiple stoplight formats and/or multiple conditional cell formats):

Discoverer Viewer first applies the stoplight formats first in the order in which they are listed.
Discoverer Viewer then applies conditional formats that don't conflict with the stoplight formats.
Where a conflict exists between conditional formats and stoplight formats, Discoverer Viewer applies the stoplight formats.
You can change the order in which the formats are applied by using the icons in the Move Up and Move Down columns.

Name

This read-only field displays the name of the conditional format.

Attributes

This read-only field shows what the format looks like.

Move Up

Use the move up icon in this column to move a conditional format up in the list of conditional formats. One click moves a conditional format up one row at a time. Clicking the icon in the Move Up column enables you to change the order in which the stoplight formats or other conditional formats are applied.

Move Down

Use the move down icon in this column to move a conditional format down in the list of conditional formats. One click moves a conditional format down one row at a time. Clicking the icon in the Move Down column enables you to change the order in which the stoplight formats or other conditional formats are applied.

Edit

Use this icon to display either the "Create Conditional Cell Format page", the "Create Stoplight Format page" page, or the "Create Conditional Header Format page". these pages enable you to edit the format that is selected in the <Conditional formats list>.

Delete

Use this icon to delete the selected conditional format.

Clear All Formatting

Use this button to deselect all of the Display check boxes and to remove all formatting entries that were defined using the Toolbar (for more information, see "Worksheet Display page: (Table/Crosstab tools)").

Notes

If you save a workbook in Discoverer Viewer, Discoverer Viewer does not save any conditional or stoplight formatting information for future use.