Validation
Dear sir
First I would like to thank you about this web-site it's so helpful,
If u can help me, I want to make a program on oracle and excel is part
of it I will give u an example about what I need to do in excel:
Suppose I have 4 cells A1 B1 C1 D1, in D1 there is a fixed value lets
say 10
I want a restriction that limit the user not to enter a value in A1 B1
C1 cells but less than or equal the value in D1 that's men
A1+B1+C1<=D1
And if the user enter a value in one of the three cells that make the
summation of three cells grater than D1=10, then must display a
message and return the cursor to the cell that make the error and
color it with red
That's all I need, I will be grateful if u help me in this issue
Best regards
Mohad Haddad
|