Conditional Data Validation

[Patience]

This is something I have just thought about which might help me a little bit on creating a workbook for other users.

Is it possible to put data validation on a cell dependent on the contents of a different cell.

Eg if A1=1, B1 can only contain "YES" OR "NO", but if A1=2, B1 can only contain "Oui" or "Non".

Does/can this work?

Thanks.

 

[pgc01]

Hi Patience

Use in B1 Data>Validation>Settings>Custom:

=OR(AND(A1=1,OR(B1="Yes",B1="No")),AND(A1=2,OR(B1="Oui",B1="Non")))

Hope this helps
PGC