I have a spreadsheet that shows a grouping of data. Each column represents a message transaction. Each row represents a specific segment. A message can contain one or many segments. What I would like to do is that when an entire column is selected each row that has a value for that column to also be selected. This will highlight what segments are used in that particular message.
ie.
A B C D
1 X X X
2 X
3 X X
If Column B is selected Rows 1,2,3 would also be selected. If column D were selected row 1 would be selected. This would only happen if the entire column was selected. If an individual cell is selected then nothing else would be selected.
Thanks