Custom Data Validation for specific text and numbers only
 

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),E50),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

Custom Data Validation for specific text and numbers only
 

Check your earlier post.

Antonio wrote:

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),E50),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

--

Dave Peterson

Custom Data Validation for specific text and numbers only
 

Thanks Dave!

"Antonio" wrote:

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),E50),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