Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation
Can I set a validation for a range of cells so that the sum of the range must
always equal a certain value? For example, if I attempt to change one of the values in cells a1:f1 I would like the user to be given a message that the sum of the range must be equal to "1" and so they are aware that another change in the range must be made to either increase or decrease other values so that the sum is not affected. Thank you in advance for your assistance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation with hyperlinks | Excel Worksheet Functions | |||
validation list--list depends on the selection of first list | New Users to Excel | |||
data validation lists | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Data Validation Window? | Excel Discussion (Misc queries) |