I am looking for some Data Validation formulas to prevent users to enter a data in a cell if there is a value present in another cell. I'm not sure if this can be done by formulas or VBA. I attached the file for reference. Here is the criteria:
Data Validation criteria
- Do not want users to be able to input data in both Col E and Col F. Only a value allowed in one of the 2 columns per row (Option 1 or Option 2)
- So if a value is present in Col E and someone tries to input a value in Col F in the same row, I would a like a pop-up message to say "Invalid Entry: Please remove amount from Column F to enter %"
- So if a value is present in Col F and someone tries to input a value in Col E in the same row, I would a like a pop-up message to say "Invalid Entry: Please remove amount from Column E to enter Amount"
Thank you!
10% has been sent via PayPal