Create Conditional Header Format page

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

For example, to format the header cell text of the Year column in blue if the Year is 2000, you might:

Select Year from the Dimension drop down list.
Select the Selected Calendar Year check box.
Move 2000 from the Available field to the Selected field.
Select a blue color from the Font color picker.

This page is also displayed as:

Edit Header Format page

For more information about other conditional formatting options, see:

"Create Conditional Cell Format page"

"Create Stoplight Format page"

Name

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

Dimension

Use this drop down list to select the dimension (e.g. Year, Region, City) to which you apply the conditional format.

Note: This field is only displayed with crosstab worksheets.

Apply format to

Use these radio buttons to specify the header values to apply the conditional header format to as follows:

Entire <Table/Crosstab> or Any <Dimension>

Use this radio button to apply the current format to any value. For example, if the selected dimension was Region, the current format would be applied to the header in any region in the worksheet (e.g. East, West, or Central).
Selected <Columns> or Selected <Dimensions>

Use this radio button to apply the current format to one or more available values. For example, if the selected dimension is Region, the values for Region might be East, West, and Central.

Use this drop down list to select an item or measure to apply a conditional format to.

Available/Selected

The Available field shows the members in the worksheet. The Selected field shows those members to which the conditional format will apply.

Use these fields to move the members to and from the Available and Selected fields.

Bold

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

Italic

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

Underline

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

Background

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

Font

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

Border

Use this area to select border line styles and border line color formatting for the selected header 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 header cells.

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

Notes

This page uses standard keyboard navigation. If you are not using a mouse, you cannot use the color grids to select a color. Instead, enter RGB values (e.g. #330033 for the color black)