Allow only certain values into a cell

Please sign up for the course before starting the lesson.

Everything before is focused on allowing or not allowing a user to do something in a cell. So they either can change a cell or not. But what if you want them to change the contents of a cell but limit the options e.g. they must enter a number bigger than 10%.

Different levels of protecting excel spreadsheets

To see the full course contents click here.

Lesson tags: vlookup
Back to: Advanced Excel Course > Protecting spreadsheet information and formulas