| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Custom Validation
my validation criterias for the cell a
input must be divisble to 4 and larger than 100 I can only use = Mod(A1, 4)=0 , but not able to set the 2nd criteria in one cell. Would anyone know the way to fulfill both? thx! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom validation | Excel Discussion (Misc queries) | |||
| Custom Format and Data Validation Q | Excel Worksheet Functions | |||
| custom validation | Excel Worksheet Functions | |||
| Excel2000: Custom data validation and named ranges | Excel Discussion (Misc queries) | |||
| Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
Threaded Mode
