How to set conditional formats

1	To define the condition, right-click a cross tab element on which to display conditional formatting. From the menu, choose Format→Conditional Formatting.

2	In Conditional Formatting, as shown in Figure 2-20, create a rule specifying the following information:

The condition that must be true to apply the format, such as revenue greater than or equal to 45000, as shown in Figure 2-20.

Figure 2-20

Defining conditional formatting

Choose Font to select formatting attributes.

In Font, set formatting attributes:

Select font, size, color, and background color.

Select styles: bold, italic, or underline.

Select an alignment option: Align Left, Align Center, or Align Right.

Figure 2-21 displays the choices of white text color (RGB(255,255,255)), gray background color (RGB(192,192,192)), and bold style on Font.

Figure 2-21

Setting font formatting options

Choose OK.

3	In Conditional Formatting, choose OK. In the cross tab in Figure 2-22, revenue values greater than or equal to $45,000 appear as bold, white text on a gray background.

Figure 2-22

Highlighting revenue values greater than or equal to $45,000

4	To add another rule, right-click a cell and choose Format→Conditional Formatting. Then, on Conditional Formatting, choose Add Rule.

Conditional Formatting displays fields for you to provide a new rule.

How to delete a conditional formatting rule

1	Right-click a cross tab element. From the menu, choose Format→Conditional Formatting.

2	In Conditional Formatting, choose Delete Rule for each conditional formatting rule that you want to remove. Choose OK.

© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy

BIRT iHub 2