Data Validation Question

  • Thread starter Thread starter Satan
  • Start date Start date
S

Satan

I want to be able to create a drop-down list (which I know how to do),
but I want an error message to appear when a certain value is
selected. For instance, let's say my list contains 3 choices:

yes
no
maybe


Whenever "no" is selected, I want an error message to appear. I can't
figure out how to make a drop-down list AND create a error box using
data validation.

Also, I want an error message to appear no matter what value is
selected.
Any help would be appreciated. Thanks.
 
Data validation supports showing a message when the cell is selected and
when an invalid entry is entered.

To show a message for "no", in an adjacent cell use a formula like

=if(A1="no","Message","")
 
Back
Top