In this post we will be setting a minimum input value for cells within an Excel spreadsheet. To achieve this we will use a data validation function to restrict the type of data or the values that users enter into a cell. In this example we will be setting the minimum input value for a cell to 50. This means if a user were to enter a value less than 50, an error message will appear.
To set the minimum input value for cells within an Excel spreadsheet carry out the steps below.
- Start by highlighting the cells that you are wanting a minimum input applied to.
- With the cells selected click on the ‘Data’ tab along the top and then click ‘Data Validation…’ within the ribbon.
- A new window will appear, within the ‘Allow’ dropdown select ‘Whole Number’.
- Within the ‘Data’ dropdown select ‘greater than’ and then enter in a minimum value. In our example the maximum value is ’50’. Once done click ‘OK’.
This will apply the data validation across all the highlighted cells. Should the user enter in a number below ’50’ an error message as seen below appears. If you found this useful take a look at some of our other content around Microsoft Excel by clicking here.
If you are wanting to change the error message click on the ‘Error Alert’ tab and enter in your desired ‘Title’ and ‘Error Message’.