Excel, Chapter 1Theory

156.36

If you type 156.3568in a cell with the custom number format code ###.## applied, this result will display.

Conditional Formatting Rules Manager

Open this dialog box to create, edit, or delete a conditional formatting rule.

Custom AutoFilter

Open this dialog box to filter by more than one criterion using a comparison operator.

Sort

Open this dialog box to organize cells in a worksheet by more than one color.

Format Cells dialog box with Number tab active

Open this dialog box with this tab active to format a selected range as fractions and select the type of fraction to display.

Highlight Cells Rules

Point to this option at the Conditional Formatting button drop-down list to format cells based on a comparison operator such as greater than.

exponential

Scientific formatting is used by scientists and others who need to write very large numbers using this notation.

Locale

The special number format options displayed in the Type list box are dependent on the setting in this option box.

Top/Bottom Rules

To conditionally format a range using the Above Average condition, click this option at the Conditional Formatting button drop-down list.

Wrap text or Shrink to fit

Use either of these two text control options to format a long label within the existing column width.

SUBSTITUTE

Use this text function to change existing text in the source cell to new text in the formula cell.

conditional formatting

A worksheet can be filtered by a cell color that has been applied manually or by this feature.

Icon Sets

Excel uses threshold values to classify data into three to five categories when applying conditional formatting using this option.

Use a formula to determine which cells to format

Click this option in the Select a Rule Type section of the New Formatting Rule dialog box to create a rule that conditionally formats cells based on the value(s) in another cell.