| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation of cells who is dependent on each other
I'm working in a worksheet where I have three cells, in which it is only
allowed to fill in values in one of them. How do I make a validation rule, which give an error-message, if I'm trying to fill values in more than one. Jane |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validation of cells who is dependent on each other
Try:
Assume data is in cells A1 to C1 Highlight these cells, select Data Validation, Select CUSTOM and set formula to: =COUNTA(A1:C1)=1 Set error message e.g. "Only enter a value in one of the cells A1 to C1" OK HTH "Jane" wrote: I'm working in a worksheet where I have three cells, in which it is only allowed to fill in values in one of them. How do I make a validation rule, which give an error-message, if I'm trying to fill values in more than one. Jane |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validation of cells who is dependent on each other
Thanks a lot!
-- Jane "Toppers" skrev: Try: Assume data is in cells A1 to C1 Highlight these cells, select Data Validation, Select CUSTOM and set formula to: =COUNTA(A1:C1)=1 Set error message e.g. "Only enter a value in one of the cells A1 to C1" OK HTH "Jane" wrote: I'm working in a worksheet where I have three cells, in which it is only allowed to fill in values in one of them. How do I make a validation rule, which give an error-message, if I'm trying to fill values in more than one. Jane |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dependent lists on data validation | Excel Discussion (Misc queries) | |||
| Data Validation and Dependent Lists Q | Excel Worksheet Functions | |||
| Data Validation & Dependent Lists | Excel Worksheet Functions | |||
| custom dependent list validation | Excel Worksheet Functions | |||
| Dependent List- Data Validation | Excel Worksheet Functions | |||
Hybrid Mode
