Multiple condition data validation
Dear Ron & Paul
Many thanks for the suggestions. Sorted now using the non-case-sensitive
option.
--
Ian
--
"IanC" wrote in message ...
Is it possible to set up data validation to allow only numbers greater
than or equal to zero OR text equal to n/a.
I have check sheets for machine maintenance with specific tests listed and
cells formatted to accept results. These results are numeric (=0) but
there are some machines without certain options fitted so some checks are
not relevant. I would like to allow the user to enter n/a in these cells
if the check is not required.
Any ideas?
--
Ian
--
|