Microsoft Office Tutorials and References
In Depth Information
Verifying Formulas Using Range Finder
Conditional Formatting Operators
As shown in Figure 2 – 48, the second text box in the Edit the Rule Description
area in the New Formatting Rule dialog box allows you to select a relational operator,
such as less than, to use in the condition. The eight different relational operators from
which you can choose for conditional formatting in the New Formatting Rule dialog
box are summarized in Table 2 – 5.
Table 2 – 5 Summary of Conditional Formatting Relational Operators
Cell value is between two numbers
Cell value is not between two numbers
Cell value is equal to a number
not equal to
Cell value is not equal to a number
Cell value is greater than a number
Cell value is less than a number
greater than or equal to
Cell value is greater than or equal to a number
less than or equal to
Cell value is less than or equal to a number
Changing Column Width and Row Height
When Excel starts and displays a blank worksheet on the screen, all of the
columns have a default width of 8.43 characters, or 64 pixels. These values may change
depending on the theme applied to the workbook. For example, in this chapter, the
Basis theme was applied to the workbook, resulting in columns having a default width
of 8.38 characters. A character is dened as a letter, number, symbol, or punctuation
mark in 11-point Calibri font, the default font used by Excel. An average of 8.43
characters in 11-point Calibri font will t in a cell.
Another measure of the height and width of cells is pixels. A pixel , which is short
for picture element, is a dot on the screen that contains a color. The size of the dot is based
on your screen’s resolution. At the resolution of 1366 3 768 used in this topic, 1366 pixels
appear across the screen and 768 pixels appear down the screen for a total of 1,049,088
pixels. It is these 1,049,088 pixels that form the font and other items you see on the screen.
The default row height in a blank worksheet is 15 points (or 20 pixels). Recall
from Chapter 1 that a point is equal to 1/72 of an inch. Thus, 15 points is equal to
about 1/5 of an inch. You can change the width of the columns or height of the rows at
any time to make the worksheet easier to read or to ensure that Excel displays an entry
properly in a cell.
1 ENTER FORMULAS | 2 ENTER FUNCTIONS | 3 VERIFY FORMULAS
4 FORMAT WORKSHEET | 5 CHECK SPELLING | 6 PRINT WORKSHEET
To Change Column Width
When changing the column width, you can set the width manually or you can instruct Excel to size the
column to best t. Best t means that the width of the column will be increased or decreased so that the widest
entry will t in the column. Why? Sometimes, you may prefer more or less white space in a column than best t provides.
To change the white space, Excel allows you to change column widths manually.
When the format you assign to a cell causes the entry to exceed the width of a column, Excel automatically
changes the column width to best t. If you do not assign a format to a cell or cells in a column, the column
width will remain 8.43 characters. To set a column width to best t, double-tap or double-click the right
boundary of the column heading above row 1.
The steps on the following pages change the column widths as follows: column A and B to best t; column G
to 10.25 characters; columns C, D, and H to 7.50 characters; and columns E, F, and I to 10.50 characters.