Working with fills, patterns, and borders

Quattro Pro lets you fill the cell backgrounds with colors and patterns. You can also use colors to identify data ranges and change the color of specific types of data, such as values above or below a specified range and ERR values. You can color-code spreadsheet tabs. For example, you can make all tabs for expenses one color and all tabs for revenue another color.

Quattro Pro also lets you add borders to cells setting the style, thickness, and color of the border lines. You can also draw a diagonal line through a cell, which enables you to cross-out a cell. In addition, you can add lines for total and grand total columns in a spreadsheet.


To fill the cell background

Wordperfect Quattro Pro btnbacktotopproc Working with fills, patterns, and borders
1.
 
Select a cell.
2.
 
Click Format Wordperfect Quattro Pro onestep Working with fills, patterns, and borders Selection properties.
3.
 
Click the Fill/pattern tab.
4.
 
Click a pattern button on the pattern palette.
5.
 
Open the Color picker, and click a color.

Wordperfect Quattro Pro pgx clrplt Working with fills, patterns, and borders

6.
 
Open the Background color picker, and click a background color.

To add color to a range of data

Wordperfect Quattro Pro btnbacktotopproc Working with fills, patterns, and borders
1.
 
Click FormatWordperfect Quattro Pro onestep Working with fills, patterns, and borders 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 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 code.
8.
 
Enable the Enable check box.

Wordperfect Quattro Pro tip Working with fills, patterns, and borders

 
You can also add color to a range of data by right-clicking a spreadsheet tab and clicking Sheet properties.

To color-code a spreadsheet tab

Wordperfect Quattro Pro btnbacktotopproc Working with fills, patterns, and borders
1.
 
Click Format Wordperfect Quattro Pro onestep Working with fills, patterns, and borders Sheet properties.
2.
 
Click the Tab color tab.
3.
 
Disable the Use system color check box.
4.
 
Open the color picker and click a color on the color palette.

Wordperfect Quattro Pro tip Working with fills, patterns, and borders

 
You can also color-code a spreadsheet tab by right-clicking a spreadsheet tab and clicking Sheet properties.

To add a border to cells

Wordperfect Quattro Pro btnbacktotopproc Working with fills, patterns, and borders
1.
 
Select the cells to which you want to add a border.
2.
 
Click Format Wordperfect Quattro Pro onestep Working with fills, patterns, and borders Selection properties.
3.
 
Click the Border tab.
4.
 
In the Border properties area, open the Type Wordperfect Quattro Pro pgx bordertype Working with fills, patterns, and borders picker, and click a border type.
5.
 
Open the Color picker, and click a color.

Wordperfect Quattro Pro pgx clrplt Working with fills, patterns, and borders

6.
 
Click one of the following buttons:
All — applies the borders to all the grid lines of the cell selection
Outline — applies the borders to only the exterior grid lines of the cell selection
Inside — applies the borders to only the interior grid lines of the cell selection
Verticals — applies the border to only the vertical gridlines of the cell selection
Horizontals — applies the border to only the horizontal gridlines of the cell selection

Wordperfect Quattro Pro note Working with fills, patterns, and borders

 
You can use the sample box to indicate where to draw lines on selected cells.

Wordperfect Quattro Pro tip Working with fills, patterns, and borders

 
You can remove lines in a border by clicking a line, opening the Type Wordperfect Quattro Pro pgx bordertype Working with fills, patterns, and borders picker in the Border properties area and clicking No line.
 
You can also clear all segments of a selection by clicking Clear selection.

To draw a diagonal line throu
gh a cell

Wordperfect Quattro Pro btnbacktotopproc Working with fills, patterns, and borders
1.
 
Select the cells to which you want to add a diagonal line.
If you choose a range of cells, a diagonal line is inserted in each cell in the range.
2.
 
Click FormatWordperfect Quattro Pro onestep Working with fills, patterns, and borders Selection properties.
3.
 
Click the Border tab.
4.
 
In the Border properties area, open the Type Wordperfect Quattro Pro pgx bordertype Working with fills, patterns, and borders picker, and click a border type.
5.
 
Open the Color picker, and click a color.

Wordperfect Quattro Pro pgx clrplt Working with fills, patterns, and borders

6.
 
In the Custom segments area, click a diagonal line segment buttons:
Left Wordperfect Quattro Pro pgx bord diag left Working with fills, patterns, and borders — draws a diagonal line from the bottom left corner to the top right corner of a cell
Right Wordperfect Quattro Pro pgx bord diag right Working with fills, patterns, and borders — draws a diagonal line from the bottom right corner to the top left corner of a cell
If you enable both buttons, the cell is crossed-out.

To add a line for totals and grand totals

Wordperfect Quattro Pro btnbacktotopproc Working with fills, patterns, and borders
1.
 
Select the cells to which you want to add lines.
2.
 
Click Format Wordperfect Quattro Pro onestep Working with fills, patterns, and borders Selection properties.
3.
 
Click the Cell font tab.
4.
 
In the Accounting style area, enable one of the following options:
Single line
Double line

Working with fills, patterns, and borders