Data/Validation question

**Ron Coderre** · 09-01-2013, 02:28 PM

Just to clarify....
Regarding the Ignore Blanks setting on Data Validation.

If your list source is a Named Range (not just a range address) that contains blank cells...
• Ignore Blanks: Checked
...Allows users to enter non-list items in the DV cell(s)

• Ignore Blanks: UN-Checked
...Prevents non-list items from being entered.

Also, I need a clarification...
Are you trying to only allow numbers between 0 and 25, inclusive, and blanks and spaces?
Something else?

**bidwin** · 09-01-2013, 05:16 PM

Originally Posted by Ron Coderre

Just to clarify....
Regarding the Ignore Blanks setting on Data Validation.

If your list source is a Named Range (not just a range address) that contains blank cells...
• Ignore Blanks: Checked
...Allows users to enter non-list items in the DV cell(s)

I'm not using a list - I'm using the "custom" option with a formula.

• Ignore Blanks: UN-Checked
...Prevents non-list items from being entered.

Also, I need a clarification...
Are you trying to only allow numbers between 0 and 25, inclusive, and blanks and spaces?
Something else?

Nope, just those three criteria.