Setting a range

If you want to set a limit to the values that should be registered, you can identify a range. When you click on the  button, you will get a pop-up dialog that allows you to set the bottom value and top value of the range. You can also double-click on the cell to open this dialog window.

The drop-down list on the left of the value field allows you to specify whether the registered value has to be greater than, greater than or equal to, or equal to the minimum value. For the maximum value, you can set whether the value has to be smaller than, smaller than or equal to, or equal to this value.

You do not need to set both the minimum and maximum value. For instance, if you want to avoid negative values, you can set the minimum value to greater than or equal to zero.