changes in data validation are not reflected

  • Thread starter Thread starter DannyJ
  • Start date Start date
D

DannyJ

Hi folks,

I have a data validation that says
cell e22 must be greater than or equal to cell M12 this works fine.
However if i change the value in cell M12 so that e22 is not greater than or
equal to M12 an error message does not appear.

thoughts anyone?

Many thanks,

Danny
 
DannyJ wrote...
I have a data validation that says
cell e22 must be greater than or equal to cell M12 this works fine.
However if i change the value in cell M12 so that e22 is not greater than or
equal to M12 an error message does not appear.

thoughts anyone?
Click to expand...

Data validation doesn't work the way you seem to believe it does. If
you give cell E22 the validation rule that it must be >=M12, all it'll
do is prevent you from entering in E22 a value less than the value of
M12. The error message only displays if you try to enter a value in E22
less than M12. If you enter anything in any other cell, including M12,
*NOTHING* will happen in cell E22.

If you want E22>=M12, then don't you also want M12<=E22, so you could
give M12 the validation rule that it must always be less than or equal
to E22.

There's a lesson here: data validation is toy functionality. Also, it's
easily broken (you can paste anything into a cell with a validation
rule - simple paste and you blow away the validation rule, paste as
value and the validation rule isn't triggerred). If you want robust
validation, you have to use Change and Calculate event handlers and
implement your validation rules in VBA.
 
Back
Top