how do i add an error message if someone enters wrong data

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Im looking at setting up a worksheet and want some error messages to appear
if operators but incorrect information. Please help?!

Mike
 
On your menu bar you will find

Data -> Validation

This allows you to validate the data enetered in a cell and dispay an error
/ alert message if it does not meet certain standards.
 
Thanks Jim,

Done that but one problem.... I want the error message to come up if it does
not = 100. This is generated from two other cells (a formula). ie 30 + 60
do not = 100 so i want the error to come up then. How can i make this work?
I know i could just higlight the cell in conditional formatting but i need it
to be more obvious

Thanks
 
Use Custom data validation... This checks Cells B2:C2 to ensure that they
equal 100

=NOT(AND(COUNT($B2:$C2)>1, SUM($B2:$C2)<>100))

The count is there to only validate if both cells are filled in.
 
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

min,average>0 if 52 cells read zero 2
Create a yes no message on a command button on click 0
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
How do I add a row to a data table? 3
Error Message for REPORT if wrong number entered 2
Error Message for FORM/QUERY if wrong number entered 2
Error Message Box 1
How do i reference an external workbook for data validation? 2

Back
Top