Highlight rows with the same content as a column

[magicdude3000]

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!

[Pauleyb]

Okay, sounds like you are a programmer and probably would do better with some 'teaching' rather than a straight solution. Basically, you want to use event handlers; specifically, the worksheet SelectionChange event which will occur whenever a new cell or range is selected.

Here is a good page on events in general:
http://www.cpearson.com/excel/Events.aspx
Here is the microsoft page on the SelectionChange event:
https://msdn.microsoft.com/EN-US/lib.../ff194470.aspx

Then, to find common text, you can use the .find method:
https://msdn.microsoft.com/en-us/lib.../ff839746.aspx

[magicdude3000]

This is perfect I'll try it out tonight. And yeah lol

Okay, sounds like you are a programmer and probably would do better with some 'teaching' rather than a straight solution. Basically, you want to use event handlers; specifically, the worksheet SelectionChange event which will occur whenever a new cell or range is selected.

Here is a good page on events in general:
http://www.cpearson.com/excel/Events.aspx
Here is the microsoft page on the SelectionChange event:
https://msdn.microsoft.com/EN-US/lib.../ff194470.aspx

Then, to find common text, you can use the .find method:
https://msdn.microsoft.com/en-us/lib.../ff839746.aspx