M
Mike
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.
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.