Forum Discussion
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...
If, 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,””)
=IF(NOT(ISBLANK(F3)),C3>0,””)