Restricting Users to make enrty depending on two columns.

[thebeastslayer]

COL A and B has some blank and non blank rows . User are allowed to choose either from COL A or COL B by typing A or B in COL C provided that the cells in corresponding COL are non empty if they are empty restrict user and display msgbox . Sample excel file is attached . (I am not sure if this can be done without VBA )

[AlphaFrog]

Use the Data Validation feature

Select C2:C15

Select from the menu: Data\ Data Validation

Allow: Custom
Formula: =OR(AND(A2<>"",C2="A"),AND(B2<>"",C2="B"), C2="")
Uncheck Ignore Blanks

Error Alert tab:

Title: Invalid Entry
Message: Type in 'A' if there is a Main Bank Account, or 'B' if there is an Alternate Bank Account.