help with Excel - how to create an alert message?

Question

I want to create an alert message when someone type in the wrong number. for example, only values from 1 to 50 is acceptable. If one keys in 67, a message will pop up.

how to do that? Please help.
Thank you :-*

Answer 1

hey Hado,
Excel has a tool that gives a professional touch to your job.

Let me teach you how it works:

1) Select a range of cells where user have to input numbers.
2) Select DATA from menu
3) Select "Validation" from Data menu
Data Validation screen comes here with 3 tabs. You will configure Settings tab and Error Alert tab only.

4) Select the following parameters:
Allow : Select Whole number
Data : Select Between
Minimun : Enter 1
Maximun : Enter 50

5) Go to Error Alert tab
Style : Stop
Title : Enter the message you want to display.
i.e. "Sorry, wrong number"
Error Message : Enter numbers from 1 to 50 only!

6) Click OK when you are done!

7) Test it. you'll be the best at your office!!

It is easy, quick done, professional and put you on excel expert site.

hope it helps you.

Answer 2

let's think that your value is to be entered on cell A1
on cell B1 you can enter =if(A1>50,"the value is incorrect")
try that. is the easiest way to do this, there are others that would involve a pop up message and other methods of validation that will not even let you enter the value, but try this first.