Excel Exclusion

Question

I am drafting an excel document for acquisition reviews, and want to exclude a cell if value in 7D=Specified Value it will exclude Example: Row 23 Column D question then grays out that cell, so the user knows it is not applicable to them.

For example:

Row1- Dropdown List: 4 options---If option 1 is selected, gray out question 4, 5, and 6.

Row 2-Dropdown List: 4 options--If option 2 is selected, gray out question 2, 7, and 8.

Row 3-1. List your favorite foods.

Row 4-2. List your favorite drinks.

3. List your favorite restaurant.
4. List your favorite color.
5. List your favorite holiday.
6. List your favorite season.
7. List your favorite shoes.
8. List your favorite socks.
9. List your favorite pants.
10. List your favorite shirt.

The point is having different programs in different pathways/milestones and having a review process to generate what questions are applicable to you and your system/program. Not very experienced with excel formulas, and would greatly appreciate some help.

-Matthew Gibson

Answer 1

interesting topic.

How about a form like this.

https://b23.tv/JKDhp3L

Answer 2

if value in 7D=Specified Value it will exclude Example: Row 23 Column D question then grays out that cell

Matthew,

add a conditional formatting using a formula e.g. when 123 is your specific value: =$D$7=123 and apply to row 23. https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f

Andreas.