Highlighting row containing specific word in specific column
Hi!
I am working with a project where we are using a simple excel file with data on our personell.
I would like to create a function in the spreadsheet that highlights certain rows based on what groups the person is part of.
I've made a small example file representing the data.
I would like to be able to select cell E2 and that would highlight cells A2:C2 and A6:C6 because both those people are in the group "economy".
If selecting the cell E2 is not possible as a trigger, then a macro button in G2 would suffice.
Is there a way to create this functionality and can someone guide me in how to do this?