Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Validation (Drop down list vs simple text length validation) | Excel Programming | |||
Validation (Drop down list vs simple text length validation) | Excel Programming | |||
Validation (Drop down list vs simple text length validation) | Excel Programming |