| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data validation on data validation function
Hi,
In the data validation function using list, if you manually insert a value that doesn't exist within this list then you get an error. If you chose to ignore it then the value stays in the cell even though it doesn't exist from the available list of entries. My question is, how do I get Excel to inform me which cells within the workbook have such a case? Is there a way to run something to re-check all relevant cells that are using data validation and whether the value is an valid entry. Hope my question makes sense! Thanks in advance Peter |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| What function to use? Data Validation or IF | Setting up and Configuration of Excel | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Threaded Mode
