Suppose cell A2 I want a drop down list via Data\validation\Allow\List say x,y,z At the same time another validation rule is needed if A1 is blank no entry can be made in A2 for which validation rule is Data\Validation\Allow\Custom =NOT(COUNTBLANK(A1))
How both these validation can be made??????????