Hello all,
I find data validation to be a useful tool in excel 2019.
In cell A2 if the value = A then allow both positive and negative integers, If not an A then allow only positive integers, and if blank then do not allow anything. How to achieve this via Data Validation?
Please note that exact zero "0" value should not be allowed in any condition.
Many thanks and appreciations.
I find data validation to be a useful tool in excel 2019.
In cell A2 if the value = A then allow both positive and negative integers, If not an A then allow only positive integers, and if blank then do not allow anything. How to achieve this via Data Validation?
Please note that exact zero "0" value should not be allowed in any condition.
Many thanks and appreciations.