Controlling Data Input in Excel

In real life you often have to compare the lists created by different people, at different times, contain typos, extra spaces, data in the wrong format, etc. In this article, we will consider not only the comparison of lists, but also prepare them for the comparison.

Use Conditional formatting to highlight on MS EXCEL sheet blank user cells.

Sometimes user needs to limit the opportunity for the input of a specific pattern. For example, when writing articles it is known that the correct article has a length of 6 characters, starts with a Latin letter, followed by 4 digits, then 1 letter in Russian. Teach EXCEL to block the entry of data corresponding to this template.

If grid data is sometimes necessary to restrict the option of entering a specific list of values. For example, when filling out the statement enter the names of the employees from the keyboard can be replaced by selection from a predefined list (transcript).

Use the tool data Validation to prevent the user from entering incorrect values in MS EXCEL.

Create a formula to signal to the user when they enter an incorrect value. Under the "incorrect value" here will understand the meaning, does not belong to the specified range.

If grid data is sometimes necessary to restrict the option of entering a specific list of values. For example, when filling out the statement enter the names of the employees from the keyboard can be replaced by selection from a predefined list (time sheet), and to control the re-entry of names in the list, use Conditional formatting.

Use Conditional formatting to signal the user of MS EXCEL of belonging to a particular date range.

Write a formula to check the achievements of 20 years of age on today's date. The formula must return TRUE, if someone already has a full 20 years, otherwise the formula should return the value FALSE.

Use Conditional formatting for the allocation of numbers belonging to subscribers of Moscow.

Use Conditional formatting to signal to the user when they enter an incorrect value. Under the "incorrect value" here will understand the meaning, does not belong to the specified range.