Require Column D Based on Column C Answer

%3CLINGO-SUB%20id%3D%22lingo-sub-2264656%22%20slang%3D%22en-US%22%3ERequire%20Column%20D%20Based%20on%20Column%20C%20Answer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2264656%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20dropdown%20choice%20in%20column%20C%20(yes%2Fno).%20I%20need%20column%20D%20to%20be%20a%20required%20field%20if%20the%20answer%20in%20column%20C%20is%20%22yes%22.%20That%20needs%20to%20be%20a%20dropdown%20box%20with%20%22yes%2Fno%22%20choices.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%20If%20the%20dropdown%20choice%20in%20C2%20is%20%22yes%22%2C%20then%20D2%20HAS%20to%20be%20answered%20%22yes%20or%20no%22.%20If%20C2%20is%20%22no%22%2C%20D2%20does%20not%20need%20to%20be%20completed.%20The%20answers%20in%20column%20D%20need%20to%20be%20based%20on%20the%20answer%20in%20column%20C.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2264656%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have a dropdown choice in column C (yes/no). I need column D to be a required field if the answer in column C is "yes". That needs to be a dropdown box with "yes/no" choices. 

 

Example: If the dropdown choice in C2 is "yes", then D2 HAS to be answered "yes or no". If C2 is "no", D2 does not need to be completed. The answers in column D need to be based on the answer in column C.

0 Replies