Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data validation dependent on value in another cell.
I would like to limit the input into a cell (y or n), based on the value in
the cell above it, (also y or n). So if one cell contains "y", then the user cannot input "y" into the other cell. I'm familiar with data validation, just not sure of the proper syntax to use. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data validation dependent on value in another cell.
Assuming the cells are F1 and F2, and you are setting up F2, use DV with a
Custom type and a formula of =AND(OR(F2="Y",F2="N"),F2<F1) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Gubawatts" wrote in message ... I would like to limit the input into a cell (y or n), based on the value in the cell above it, (also y or n). So if one cell contains "y", then the user cannot input "y" into the other cell. I'm familiar with data validation, just not sure of the proper syntax to use. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data validation dependent on value in another cell.
Thanks Bob.
"Bob Phillips" wrote: Assuming the cells are F1 and F2, and you are setting up F2, use DV with a Custom type and a formula of =AND(OR(F2="Y",F2="N"),F2<F1) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Gubawatts" wrote in message ... I would like to limit the input into a cell (y or n), based on the value in the cell above it, (also y or n). So if one cell contains "y", then the user cannot input "y" into the other cell. I'm familiar with data validation, just not sure of the proper syntax to use. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how blank data validation cell after changing dependent cell? | Excel Discussion (Misc queries) | |||
Dependent Data Validation | Excel Discussion (Misc queries) | |||
Data Validation list dependent on contents of another cell | Excel Discussion (Misc queries) | |||
dependent lists on data validation | Excel Discussion (Misc queries) | |||
Dependent List- Data Validation | Excel Worksheet Functions |