Microsoft Office Tutorials and References
In Depth Information
If you click the Conditional Formatting icon on the Home tab and choose Top/
Bottom Rules, Excel can apply conditional formatting to your top (or bottom)
ten values or those values above or below the average, as shown in Figure 9-9.
Because formulas are only as accurate as the data they receive, it’s
important that your spreadsheet contains only valid data. Examples of invalid data
might be a negative number (such as –9) for a price or a decimal number
(such as 4.39) for the number of items a customer bought.
To keep your spreadsheet from accepting invalid data, you can define a cell
to accept only certain types of data, such as numbers that fall between 30
and 100. The moment someone tries to type invalid data into a cell, Excel
immediately warns you, as shown in Figure 9-10.
To define valid types of data for a cell, follow these steps:
1. Click a cell that contains data used by a formula.
2. Click the Data tab.
3. Click the Data Validation icon in the Data Tools group.
The Data Validation dialog box appears, as shown in Figure 9-11.