Each booking can reserve from zero to twelve seats. Apply an integer rule to the booking cells and test it in the app that will receive the workbook.

Set a whole-number rule on B2:B10

In an editor that supports numeric data validation, select B2:B10 and choose Whole number with a Between condition. Enter 0 for the minimum and 12 for the maximum. Choose a blocking error style if the editor offers one and the limit is mandatory.

The rule is Whole number, Between, minimum 0 and maximum 12.

Illustrated rule setup. Select only the editable cells.

Try the endpoints and a decimal

Enter 0 and 12 in a test copy, then try −1, 13, and 5.5. The last entry tests that the rule checks integers as well as the range. Decide how the sheet should treat a blank, since an unfilled booking is different from zero seats. Review existing and pasted values separately, then repeat a valid and invalid entry after reopening.

The test records accept 0 and 12 and reject minus 1, 13 and 5.5.

Illustrated input tests. Verify pasted values separately.

Microsoft’s numeric data validation instructions