Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data Validation
How do I allow input into a cell only if it meets the criteria of another
cell. If cell c3 contains "Active", allow input into D3 If cell c3 contains "Inactive" do not allow input into D3 |
#2
|
|||
|
|||
How about:
=(C3="active") And uncheck that "ignore blank" checkbox on the Data|validation|settings tab. This actually just verifies that "active" ins in C3. Anything else won't work. But if you have Active in C3, then type something in D3, then change C3, it won't have any effect on D3. JJalomo wrote: How do I allow input into a cell only if it meets the criteria of another cell. If cell c3 contains "Active", allow input into D3 If cell c3 contains "Inactive" do not allow input into D3 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation | Excel Discussion (Misc queries) | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Data Validation Window? | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |