Corel wordperfect office 2002 Benutzerhandbuch
To fill the cell background
1 Select a cell.
2 Click Format } Selection properties.
3 Click the Fill/pattern tab.
4 Click a pattern button on the pattern palette.
5 Open the Pattern color picker and click a color.
6 Open the Background color picker and click a background color.
2 Click Format } Selection properties.
3 Click the Fill/pattern tab.
4 Click a pattern button on the pattern palette.
5 Open the Pattern color picker and click a color.
6 Open the Background color picker and click a background color.
To add color to a range of data
1 Click Format } Sheet properties.
2 Click the Conditional color tab.
3 In the Smallest normal value box, type the smallest value to which you want to apply
2 Click the Conditional color tab.
3 In the Smallest normal value box, type the smallest value to which you want to apply
conditional color.
4 In the Greatest normal value box, type the largest value to which you want to apply
conditional color.
5 In the Options area, enable one of the following options:
Below normal color — sets the color of cells whose values are below the smallest normal
value
Normal color — sets the color of cells whose values fall within the range set in the
Smallest normal value and Greatest normal value boxes
Above normal color — sets the color of cells whose values are above the greatest normal
value
ERR color — sets the color to use for ERR and NA values generated by formula errors
6 Click a color on the color palette.
7 Repeat steps 5 and 6 to enable a different color for as many options as you want to color
7 Repeat steps 5 and 6 to enable a different color for as many options as you want to color
code.
8 Enable the Enable check box.
You can also add color to a range of data by right-clicking a spreadsheet tab, and
clicking Sheet properties.
Editing and formatting a spreadsheet
205