Leading the way in Microsoft Office Development

Step 1 - Highlight the cells

Step 2 - Enter the Criteria

Press (Data > Validation) to display the Data Validation dialog box and select the Settings tab.

Values can be entered directly into the value box or you can use a formul (including worksheet functions).

In this example we will use a reference to a cell containing the minimum and a formula to calculate the maximum value.

These must be entered as absolute values for the range to work correctly every time.

Press OK to apply the data validation.

Step 3 - Dates Exception

You can now only enter numeric values between 10 and Max(" ") = 60

There is an exception to this though because dates and times are actually numbers.

It is possible to enter a date provided that its numeric value is within the range specified.

The range of dates that would be accepted are from ?? To ??

To ensure that dates are not displayed the cells must be formatted as a Number (and not as a Date or Time) in the (Format > Cells)(Number tab) dialog box.