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...
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.
