If I wanted to restrict a range of cells to only the values 7, 7.5, 8, 8.5, 9, 9.5, 10 and 11, what would be the formula to do that. I tried a few things and couldn't get it to work.
Also, is there any way to search out cells that have data validation applied to them?
Could you try using a list instead? Create a table with your values, name that table, and in Data Validation, select List, then reference your table range. This will prevent users from being able to enter other data than what is in the list into that cell.
Spread the love, add to the Rep
"None of us are as smart as all of us."
I figured it out.
Formula:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks