[wick3dways]

i currently have a spreadsheet where a user enters data from a list into cell column A, and data from a list into cell column D. the list for column A allows the user to select from "zone A", "zone B", "zone C", and "zone D". the list for column D allows the user to select from "Yes" or "No".

How can i make it so that an alert message appears when the user selects both Zone D and No in the same row? i want this to be allowed but it should alert the user that it is not reccommended. is this possible to make a popup when both conditions are true? thanks in advanced.

[bomb #21]

You can make a pop-up with code. Easier to use a formula in a free column, such as:

=IF(AND(A2="Zone D",D2="No"),"Zone D + 'No' not recommended","")