Forum Discussion
Ayman_Hassan
Mar 14, 2019MCT
Obligation of data entry order using data validation
Hello,
I need to create a sheet for my colleague to work on.
I set some custom data validation rules combination using AND function, and I need to add to these rules that the cell should not accept any entry unless another specific cell is filled first.
For example:
I need to restrict the entry in cell C3 using some sort of values and rules using custom AND function.
Now I need to add a restriction that cell F3 should not be empty, means that F3 should be filled first (F3 actually contains a data validation drop down list.
How to add this part to the AND formula in data validation?
PS: I tried adding And(F3<>""
and it did not work fine.
1 Reply
- TwifooSilver ContributorIf, for example, you want a value more than 0 in C3, if F3 is not blank, the your custom formula for data validation in C3 is:
=IF(NOT(ISBLANK(F3)),C3>0,””)