Warning Message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to do the following without using VBA:

If a user manually enters a value in a cell (not a list), I would like to
compare this value against a value in another column - and be able to display
a warning message if the criteria is not as expected.

For instance, if a value is entered in column A, then column B and C should
not contain any values - as this impacts connecting formulas. I could just
blank out this information - but this would impact the other calcs.
Therefore, I want to display a message to ensure the user is making the right
entries.
 
MLK --

After you select the input cell, do the following: Click >Data>Validation.
On the 'Settings' tab, click Allow: List, and then select the range of cells
containing your acceptable entries.

HTH
 
Great! Thank you.

pdberger said:
MLK --

After you select the input cell, do the following: Click >Data>Validation.
On the 'Settings' tab, click Allow: List, and then select the range of cells
containing your acceptable entries.

HTH
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

custom data validation on cells with data validation values 2
IF Statements 3
File Download - Security Warning 5
Complex search and replace macro based on input variables. 12
Formula (or code) return the largest number of duplicates in a list. 16
Lookup against concatenated source value 2
Warning Messages 3
Help needed 0

Back
Top