Is it possible to validate a list selection?

I have 2 very simple lists which include Yes and No.

The headings of the 2 columns are: Resident in California? and Resident in the USA?

If the user selects Yes to the 1st question, then by default the user must select Yes to the second question.

However, users might answer the 2nd question first. In that case, the user selects No to being resident in the USA, then by default the user must select No to being resident in California.


At this point, I'm thinking of just introducing a column for error comments and using the traditional IF statements to validate the 2 columns.

QUESTION: Is there a better solution ?