Data Valadation
Try something like this:
Select A1:B1
From the Excel main menu:
<data<validation
Allow: Custom
Formula: =($A$1-$B$1)0
Select the Error Alert tab
Title: INVALID RANGE
Error message: The A1 value must be larger than the B1 value.
Click the [OK] button
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"claude jerry" wrote:
I have the following Data
Col A Col B Col C
2 3 =A1-B1
The user enters data in Cell A1 Or Cell B1 and Cell C1 Calculates the results
I want the following
If the user enters any value in Cell A1 Or Cell B1 and the Value computed in
Cell C1 returns to Negative . he gets a pop up saying "Invalid Range"
Eg in the above Cell C Will Return -1 in such case I want to get a pop up In
valid Range
If Cell C1 Is Positive no message should be displayed
I tried Data Valadation but It does not work with Formulas . . . Or Does it
work with Formula which I am not aware of ?
Thank You
|