Hi,

Can anyone help me on how to place if statement in Data Validation. In allow Validation Criteria, which part I need choose. e.g Decimal, whole number, list, etc


basically the data as follow

A1,A2,A3,A4 Validation criteria, List B1:B5

If A1 selected, A2,A3,A4 must be empty, but if A2,A3,A4 selected, A1 must be empty

Regards,
Farid