Allow only certain values into a cell

Please purchase 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%.

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