Thread: Custom Data Val for specific text and numbers only
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Custom Data Val for specific text and numbers only
Looks good Max


Gord

On Fri, 15 Feb 2008 16:44:02 -0800, Max wrote:

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".

Based on your orig. posting, this might suffice
Select col A, apply Data Validation Custom
Formula: =OR(AND(ISNUMBER(A1),A1=10),EXACT(A1,"<RL"))

Reply With QuoteReply With Quote