Microsoft Office Tutorials and References
In Depth Information
Establishing Data-Validation Rules
Figure 1-8:
Establishing
a condition
format for
data.
To remove conditional formats, select the cells with the formats, go to
the Home tab, click the Conditional Formatting button, and choose Clear
Rules Clear Rules from Selected Cells.
You can also establish conditional formats by selecting cells and clicking the
Quick Analysis button (or pressing Ctrl+Q). In the pop-up window, choose
Formatting and then click Greater Than or Top 10% to create a highlight-cell
or top/bottom rule.
Establishing Data-Validation Rules
By nature, people are prone to enter data incorrectly because the task of
entering data is so dull. This is why data-validation rules are invaluable. A
data-validation rule is a rule concerning what kind of data can be entered in a
cell. When you select a cell that has been given a rule, an input message tells
you what to enter, as shown in Figure 1-9. And if you enter the data
incorrectly, an error alert tells you as much, also shown in Figure 1-9.
Data-validation rules are an excellent defense against sloppy data entry and
that itchy feeling you get when you’re in the middle of an irksome task. In a
cell that records date entries, you can require dates to fall in a certain time
frame. In a cell that records text entries, you can choose an item from a list
instead of typing it yourself. In a cell that records numeric entries, you can
require the number to fall within a certain range. Table 1-1 describes the
different categories of data-validation rules.
Search JabSto ::




Custom Search