Microsoft Office Tutorials and References
In Depth Information
Data Validation
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.
Figure 9-9:
The Top/
Bottom
Rules menu
can identify
the top/bot-
tom values
or those
above/
below the
average.
Data Validation
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.
 
Search JabSto ::




Custom Search