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 en...
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.
I now get this message.
As I wrote, you need a helper cell. Meaning that you can't put the formula in F6 or G6 which results in a circular reference error.