How to use Conditional Formatting on a series of Blank Cells based on the sole answer from a different cell

0

How to use Conditional Formatting on a series of Blank Cells based solely on an answer from a different cell. I'm currently working on an Excel Survey that can be found on my web site, this survey will consist of over 50 questions; almost 40% of those questions relate solely on a trigger answer from a question that is asked in the beginning of the survey. Example, first survey question asks if the applicant is an American Citizen, if he/she answers "Yes", than I want approximately 40% of a specific set of cells to automatically change into a certain color background filled, this way the applicant does not need to waste his/her time trying to answer the rest of the survey. We want the applicant to concentrate only on those cells that have changed colors due to the trigger answer/question, just a f.y.i, the specific set of cells that we want color filled have already been formatted with data validation drop down box with multiple choices, didn't know if this affects it in anyway.

Thank you for any recommendation, Windycity

Answer
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login