Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DATA VALIDATION
First, please turn off your caps because it's the same as
yelling at people for no good reason. Data validation has two main purposes. One is to enter valid data in a cell, another is to ensure only valid entries are made if you manually type them in. Because of the first part, if you tried using data validation on a cell with a formula, you could easily overwrite the formula with one of the allowed values. Therefore you can't use data validation directly on a cell containing a formula and expect it to work. You can only use data validation to validate data. Data is raw information, not a formula. You could use data validation on the cells that are referenced with your formula. -----Original Message----- HOW CAN I USE DATA VALIDATION IN CELLS WITH FORMULA . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom data validation on cells with data validation values | Excel Worksheet Functions | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
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) |