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