Forum Discussion
Data Validation Error Message
I'm looking for the correct formula to put into the data validation for the following scenario:
If cell F6 indicates "No" and cell G6 is blank, I want an error message to pop up saying that an entry (into cell G6) is required.
Traci,
that will not work. Data validation is only for checking data that is put in a cell. You can't check for an input that isn't made.
However you can use a helper cell and display the message there.
=IF(AND(F6="No",G6=""),"Input in G6 is required.","")
Thank you for the response. However, when I put that formula in for cell G6, I get the attached error message.
I edited my reply.
