Obligation of data entry order using data validation

[Ayman Hassan]

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.

[#2]

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,””)