Custom data validation not working the way I need it to.

[jawadzy]

Cell C19 and cell E19 represent "yes" and "no" respectively. I want users to answer the yes or no question by entering an "x" in either C19 (for "yes") or E19 (for "no"). According to my understanding of custom data validation, this formula for C19 below should work. But it continues to allow entries in cell C19 that are not "x". What's going on?

Formula:
=AND(C19="x",ISBLANK(E19))

 

[JoeMo]

Cell C19 and cell E19 represent "yes" and "no" respectively. I want users to answer the yes or no question by entering an "x" in either C19 (for "yes") or E19 (for "no"). According to my understanding of custom data validation, this formula for C19 below should work. But it continues to allow entries in cell C19 that are not "x". What's going on?

Formula:
=AND(C19="x",ISBLANK(E19))

when you enter that formula under custom, be sure to uncheck the box that says "Ignore Blanks" near the top of the dialog window.

 

[jawadzy]

when you enter that formula under custom, be sure to uncheck the box that says "Ignore Blanks" near the top of the dialog window.

Awesome! Thanks a ton Joe!