| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Exceptions to Validation Rules
Is there a way to create a validation rule that is used 90% of the time and
also to specify an exception for the other 10%? If I had a field that was intended to display a date and set up my validation for the date, could I then create an exception that would allow me to type "tbd" for those dates that have yet to be determined? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rules for Sheet names | Excel Discussion (Misc queries) | |||
| Data Validation Window? | Excel Discussion (Misc queries) | |||
| 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) | |||
| Validation - List - Separate Worksheet | Excel Worksheet Functions | |||
Threaded Mode
