Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom cell formats combination of numbers and text | Excel Discussion (Misc queries) | |||
custom format cell with text and numbers | Excel Discussion (Misc queries) | |||
CONDITIONAL FORMATING FINDING TEXT CONTAINING SPECIFIC NUMBERS | Excel Worksheet Functions | |||
Numbers after specific text | Excel Worksheet Functions | |||
How to format text and numbers as custom | Excel Discussion (Misc queries) |