Mark Invalid Data

Mark data outside a specified value or range.

To mark invalid data

1. Enter data in the worksheet as below.

   

2. Set the range of integers to limit from B2 to B5 by referring to Allow Values in Particular Range.
   In this example, set “300” for Minimum and “1000” for Maximum.
3. Select the data range from B2 to B5, and then click Data-Data Validation-Data Validation.
4. Check if incorrect data values are marked as below.

   

5. Modify the values as needed.

See Also

Data Validation, Clear Validation Marks

www.hancom.com