I have kind of a complicated one I can't figure out.
Set-up:
I am creating a form that consists of a 4 row x 6 cell matrix that the user will select the wanted cells in the matrix by entering a "X". Along with a 8 row x 3 row table where first column prefilled in department titles, the second column cells are driven by the selections made in the matrix (will either populate with "Yes" or "No"). The cells in the table third column of the table then is driven by the "YES' or "NO" second column cell of that row. If "NO" is shown then the third column cell is grayed out. If "YES" is shown the 3rd column will display, using data validation, a drop down list from data on the 2nd sheet of the workbook.
Problem:
If the user places a "X" in any of the cells in the third row of the matrix, everything works like I expect it to. If a "X" is placed in an of the other rows (1st, 2nd or 4th) in the matrix, and now green cells have a "X" in them, the drop down arrow for the list will show in the table, but you can not select the drop down.
When checking the 3rd column data validation settings info for the cell when it is NOT working I get the "The list source must be a delimited list, or a reference to single row or column". However, if I leave the a cell in the 2nd row selected AND select anything in the 3rd row, the 3rd column in the table starts working again, and if I go into data validation settings, the error messages doe not appear? I am so confused.
Sorry, I am sure that is hard to follow, so hopefully a picture will help explain better.
If a "X" is in any of the green cells, all the drop downs in the ACTION column will work, including if any of the peach cells have a "X" at the same time.
The problem is if NO green cells have a "X" in any of them, then the ACTION column will still show up as shown above, with the drop down arrow showing up for each cell, but you can not access the list when clicking the drop down error.
The "Yes" column of the table is driven by selections made in the matrix using a formula similar to the below formula
=IF(OR(J28="X",J29="X",L29="X",N29="X",P29="X",L28="X",N28="X",P28="X",N27="X"),"YES","--")
Then the "ACTION" column is then either Grayed out or shows a drop down selection based on what is showing in the ACTION column using both:
Conditional Formatting:
and
Data Validation:
How can if fix this? Thanks for any help.
Set-up:
I am creating a form that consists of a 4 row x 6 cell matrix that the user will select the wanted cells in the matrix by entering a "X". Along with a 8 row x 3 row table where first column prefilled in department titles, the second column cells are driven by the selections made in the matrix (will either populate with "Yes" or "No"). The cells in the table third column of the table then is driven by the "YES' or "NO" second column cell of that row. If "NO" is shown then the third column cell is grayed out. If "YES" is shown the 3rd column will display, using data validation, a drop down list from data on the 2nd sheet of the workbook.
Problem:
If the user places a "X" in any of the cells in the third row of the matrix, everything works like I expect it to. If a "X" is placed in an of the other rows (1st, 2nd or 4th) in the matrix, and now green cells have a "X" in them, the drop down arrow for the list will show in the table, but you can not select the drop down.
When checking the 3rd column data validation settings info for the cell when it is NOT working I get the "The list source must be a delimited list, or a reference to single row or column". However, if I leave the a cell in the 2nd row selected AND select anything in the 3rd row, the 3rd column in the table starts working again, and if I go into data validation settings, the error messages doe not appear? I am so confused.
Sorry, I am sure that is hard to follow, so hopefully a picture will help explain better.
If a "X" is in any of the green cells, all the drop downs in the ACTION column will work, including if any of the peach cells have a "X" at the same time.
The problem is if NO green cells have a "X" in any of them, then the ACTION column will still show up as shown above, with the drop down arrow showing up for each cell, but you can not access the list when clicking the drop down error.
The "Yes" column of the table is driven by selections made in the matrix using a formula similar to the below formula
=IF(OR(J28="X",J29="X",L29="X",N29="X",P29="X",L28="X",N28="X",P28="X",N27="X"),"YES","--")
Then the "ACTION" column is then either Grayed out or shows a drop down selection based on what is showing in the ACTION column using both:
Conditional Formatting:
and
Data Validation:
How can if fix this? Thanks for any help.
