Formula for Custom Data Validation

[Cammandk]

I want to restrict entry by user of a value unless they have already entered in other cells : I have a Minimun Value (MinVal) and Max Value (MaxVal) defined

A	B	C	D	E
1	Status	Date	Amount
2			100	Require Data validation formula to restrict
3				entry in D2 unless B2 is filled from a list in that cell and C2 has a date entry - then value in D2 to
4				be within the Min and Max entry values

<tbody>
</tbody>

 

[etaf]

this would just check that cell A and B are not empty
example for C3
=AND(A3<>"",B3<>"",C3>10,C3<20)

just apply to cells required
would that work - or is there a specific value from the list in A and do you also want to test that a valid date is entered in B