How to use the Spreadsheet Data Validation Rule Generator.
Validation rules should prevent the intended invalid values without blocking legitimate input. Include a clear error message and test boundary cases.
Make the workflow fit your task.
Define the allowed type, boundaries and blank-cell policy, then select the precise target range. Write an error message that tells the user how to correct input. Test the boundary values and an invalid value using the target spreadsheet's validation behavior.
- What you provide
- Field requirements and sheet layout.
- What you get
- Validation formula and user-facing error message.
See the input and the result.
Illustrative input and output · a teaching example, not a live WebAct run
Example input
Allow whole numbers from 1 through 10 in A2.
Completed example
Use the application's whole-number validation with limits 1 and 10; message: Enter a whole number from 1 to 10.
Load this input into the prompt, then copy it to WebAct to try the task. Your result may differ from the illustration.
Decisions and troubleshooting.
Should an optional numeric field reject an empty cell?
Only if the field is required. Decide blank handling separately from the allowed numeric interval.
Can a validation rule guarantee that imported data is correct?
No. Imports, pastes and application settings can affect enforcement. Recheck existing values as well as testing ordinary typing.
Try it with your own source.
Replace the example with your material in the task prompt. Keep the requirements you need, then copy the task into WebAct.
Customize and copy the task ↑