Change product rules for a cell

1. Select the cell.
2. Select Format » Validation rule... from the menu, or right-click the cell and select the Format » Validation rule... option.
3. Enter the Rule and the Text displayed if the rule matches the data that is entered.
4. Click OK so that, as data is entered, the data is only accepted where the rule is valid, that is, the values of the particular schemes and/or analytes in the rule pass the rule requirements.