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 |
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 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 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.
|
•
|
|
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 |
1.
|
|
Click Format 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.
|
•
|
|
You can also color-code a spreadsheet tab by right-clicking a spreadsheet tab and clicking Sheet properties.
|
To add a border to cells |
1.
|
|
Select the cells to which you want to add a border.
|
2.
|
|
Click Format Selection properties.
|
3.
|
|
Click the Border tab.
|
4.
|
|
In the Border properties area, open the Type picker, and click a border type.
|
5.
|
|
Open the Color picker, and click a color.
|
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
|
•
|
|
You can use the sample box to indicate where to draw lines on selected cells.
|
•
|
|
You can remove lines in a border by clicking a line, opening the Type 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
|
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 Format Selection properties.
|
3.
|
|
Click the Border tab.
|
4.
|
|
In the Border properties area, open the Type picker, and click a border type.
|
5.
|
|
Open the Color picker, and click a color.
|
6.
|
|
In the Custom segments area, click a diagonal line segment buttons:
|
•
|
Left — draws a diagonal line from the bottom left corner to the top right corner of a cell
|
•
|
Right — 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 |
1.
|
|
Select the cells to which you want to add lines.
|
2.
|
|
Click Format Selection properties.
|
3.
|
|
Click the Cell font tab.
|
4.
|
|
In the Accounting style area, enable one of the following options:
|
•
|
Single line
|
•
|
Double line
|