View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Silena K-K Silena K-K is offline
external usenet poster
 
Posts: 37
Default Custom Data Val for specific text and numbers only

Hi Everyone

I need to create a custom data validation rule to allow the following data
types only:

1. numbers greater than or equal to 10; or
2. if the number is less than 10 then the user can only enter the text "<RL".

I have tried AND and OR statements however once the 2. condition has been
met ie: if the number is less than 10 then the user can only enter the text
"<RL" what I have found is if I enter any text value (not numeric that
condition works) say "abc" it is accepted - which is not what I want I only
want "<RL" to be accepted.

Please help...

Thank you in advance for any suggestions, Silena