Liquid UI - WS Reference Library

3.2.4 Range Validation

Case 2: Range Validation

The third case is that validation will be performed according to a pre-specified range of values. To set this case, if it is not already selected, please do the following.
  1. Right-click on a cell in the row you want to validate and choose Data Validation from the context menu.

  2. The Data Validation wizard will appear as shown below.

  3. Select the Range radiobutton if it is not already selected as shown below and then click Next.

  4. The value entry screen will display as shown below.

  5. Enter values into the From and To fields and then click Next.
    Note: The values you enter must be such that they can be used in a range.
  6. The Finish window will display as shown below. Click Finish.

  7. The Range Validation case has now been set for this row.