Hi All,
Relatively new to excel programming. Worked with Actionscript, Python, and Google Sheets.

Anyways, my question: In the table I have now, I have a bunch of columns, each referring to a specific person. The first cell is the name, and the rest are attributes (has freckles, dislikes vegetables, etc). I want to make it so that when you select a row, each other row that shares a filled cell is highlighted. For examples, Ellie is selected, her filled in attributes are has freckles and dislikes vegetables. John has "has freckles" filled in as well, so when ellie is selected, john's row is highlighted.

Is this sort of interaction possible in Excel programming? If so, how exactly would I do it?
Thanks!