OpenOffice.org OpenOffice - 3.2 Guide de base télécharger pdf (Page 61)

100

101

As soon as you select a theme, some of the properties of the

custom styles are applied to the open spreadsheet and are

immediately visible.

3) Click OK. If you wish, you can now go to the Styles and

Formatting window to modify specific styles. These modifications

do not change the theme; they only change the appearance of this

specific spreadsheet document.

Using conditional formatting

You can set up cell formats to change depending on conditions that you

specify. For example, in a table of numbers, you can show all the values

above the average in green and all those below the average in red.

Note

To apply conditional formatting, AutoCalculate must be

enabled. Choose Tools > Cell Contents > AutoCalculate.

Conditional formatting depends upon the use of styles. If you are not

familiar with styles, please refer to Chapter 4. An easy way to set up

the required styles is to format a cell the way you want it and click the

New Style from Selection icon in the Styles and Formatting window.

After the styles are set up, here is how to use them.

1) In your spreadsheet, select the cells to which you want to apply

conditional formatting.

2) Choose Format > Conditional Formatting from the menu bar.

3) On the Conditional Formatting dialog (Figure 45), enter the

conditions. Click OK to save. The selected cells are now

formatted in the relevant style.

Cell value is / Formula is

Specifies whether conditional formatting is dependent on a cell

value or on a formula. If you select cell value is, the Cell Value

Condition box is displayed, as shown in the example. Here you can

choose from conditions including less than, greater than, between,

and others.

Parameter field

Enter a reference, value, or formula in the parameter field, or in

both parameter fields if you have selected a condition that requires

two parameters. You can also enter formulas containing relative

references.

Chapter 2 Entering, Editing, and Formatting Data 61

1 2 ... 56 57 58 59 60 61 62 63 64 65 66 ... 496 497

Commentaires sur ces manuels

Pas de commentaire

OpenOffice.org OpenOffice - 3.2 Guide de base Page 61

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel OpenOffice.org OpenOffice - 3.2