Custom Data Validation for specific text and numbers only

A

Antonio

Hi Everyone

I need to create a custom data validation rule for an entire column to allow
the following data types only:

1. numbers greater than 0
2. Specific Letters: "c", "C', "N", and "n".

So Far I've come up with this formula:

=OR(AND(ISNUMBER(E5),E5>0),EXACT(E5,"n"),EXACT(E5,"N"),EXACT(E5,"C"),EXACT(E5,"c"))

However, I cannot use the "apply these changes to all other shells with the
same settings" option because I'm using the "EXACT" feature.

I would greatly appreciate any help at all...

Thank you in advance for any suggestions, Antonio
 
D

Dave Peterson

Check your earlier post.
Hi Everyone

I need to create a custom data validation rule for an entire column to allow
the following data types only:

1. numbers greater than 0
2. Specific Letters: "c", "C', "N", and "n".

So Far I've come up with this formula:

=OR(AND(ISNUMBER(E5),E5>0),EXACT(E5,"n"),EXACT(E5,"N"),EXACT(E5,"C"),EXACT(E5,"c"))

However, I cannot use the "apply these changes to all other shells with the
same settings" option because I'm using the "EXACT" feature.

I would greatly appreciate any help at all...

Thank you in advance for any suggestions, Antonio
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation ?:Accepting both Numbers AND specific letters("N","n"," 2
Basic data validation question 4
Custom Data Val for specific text and numbers only 8
File Name changes with dates and Deleting Rows of Zeros 0
Data Validation 2
Short listing the Data Validation List 2
Data Validation to exclude blank cells 6
Data Validation and Custom Number Formats 1

Top