Create Conditional Cell Format page

Use this page to create a conditional cell format that will display worksheet data cells in a specified format, depending on a condition that you define on this page.

For example, to format the background of worksheet data cells in blue if the item Profit SUM is greater than $10,000, you might:

Select Profit Sum from the Item field.
Select Greater Than (>) from the Operator drop down list.
Enter 10,000 in the Value field.
Select a blue color from the Background color picker.

This page is also displayed as:

Edit Conditional Cell Format page

For more information about other conditional formatting options, see:

"Format Worksheet data links page"

"Conditional Formats (Table/Crosstab) page"

"Create Conditional Header Format page"

"Create Stoplight Format page"

Name

Use this field to enter a name for the conditional cell format. Discoverer Viewer generates a default name, which you can edit.

Item

Use this drop down list to select the item or measure to which you want to apply a conditional format. You must select a numeric item (e.g. Profit).

Operator

Use this drop down list to select the operator (e.g. >, <, =) that will act on the value specified in the Value field for the selected item or measure.

Value

Use this field to enter a value to apply to the selected item or measure. The value you enter in this field is applied to the selected item or measure, and is subject to the operator that you select. You must enter a number in this field.

Dimension

Use this read-only field to view the dimensions (e.g. Year, Region, City) to which you can apply the conditional format.

Note: This field is only displayed for crosstab worksheets.

Apply Format to Members

Use this read-only field to view the selected dimension members (e.g. 2002, East, Boston) to which the format will apply.

Note: This field is only displayed for crosstab worksheets.

Edit

Use this icon to display the Select <member> page where you select one or more dimension members that you want the conditional format to apply to. For example, if the member is City, you could select a specific city (e.g. Paris) to apply the conditional format to that city when the condition becomes true.

Note: This field is only displayed for crosstab worksheets.

Note: Instead of displaying a table of dimensions whose selections you can edit, Discoverer might display a message saying that the selections cannot be changed. Discoverer displays this message under the following circumstances:

When you have selected more than one range of cells.

In this case, the selection is too complex to be identified by the dimension members for the cells.
When the crosstab is in outline mode, where a member at a higher level of a hierarchy has its own row, apart from any of its children, and you have selected one of these rows.

For example, when a crosstab displays rows for countries and their cities. In outline mode, Japan would have its own row, and rows for Osaka and Tokyo would appear below it. When you apply a format to the Japan row, the selection is too complex to be represented by its dimension members, because there is no value for cities.
When the selected cells do not currently appear in the crosstab.

For example, if a row or column for Osaka has been selected, and then you drill up so that the crosstab no longer displays cities in Japan, then the selected cells do not appear in the crosstab, and the selection cannot be edited in this page. If you drill down again in Japan, then you can edit the selection in this page

Bold

Use this drop down list to select whether to apply or remove the bold format from the conditional cell format.

Italic

Use this drop down list to select whether to apply or remove the italic format from the conditional cell format.

Underline

Use this drop down list to select whether to apply or remove the underline format from the conditional cell format.

Background

Use the color picker to select a background color to apply to the conditional cell format.

Font

Use the color picker to select a font color to apply to the conditional cell format.

Border

Use this area to select border line styles and border line color formatting for the selected worksheet cells.

Note: This field is only displayed when you use an OLAP connection:

Style

Use this drop down list to select a border line style for the selected worksheet cells.

Note: This field is only displayed when you use an OLAP connection:

Line color

Use this icon to display a color palette where you select a border line color to use for the selected worksheet cells.

Note: This field is only displayed when you use an OLAP connection:

Outline, Bottom, Top, Left, Right

Use these rows to set the border specifications to use for all the selected worksheet cells.

Note: This field is only displayed when you use an OLAP connection:

Number

This area displays different content for different number categories.