Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
data validation
I would like to know if it is possible to use data validation on a
field that is summing/totalling data. IE total 1+2+3=6. is it possible in the total field to use data validation so if the total is not equal to 6 then error? I have tried this by establishing sum field totalling a1...a5 in A6 field, but when I go into input data into a1..a5 and it totals the data validation on A6 doesn't provide an error message? Any help is greatly appreciated By the way I am using Excel 2003 as the application |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Refresh existing data when changed in data validation list | New Users to Excel |