| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Validating a Not Equal To Condition
Given a column that is named "Type" (G1:G50), I tried to enter a validation
rule that does not allow "ULT" to be entered, I tried <"ULT" but that doesn't work also tried =if(g1<"ULT","") and that doesn't work. I would ultimately like to have 5 phrases that would not be allowed. Am I restricted to using VBA? I'm just trying to find the easiest way without alot of code. Any help would be appreciated.... Thanks Ambassador |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I make cell "yes" equal 1, "no" equal 0 | Excel Discussion (Misc queries) | |||
| Sum if Week Number and style is equal to any condition | Excel Discussion (Misc queries) | |||
| Sum range of a week if condition is equal to.. | Excel Discussion (Misc queries) | |||
| validating | Excel Worksheet Functions | |||
| Validating | Excel Discussion (Misc queries) | |||
Threaded Mode
