Need Help: Conditional Formatting Issues

Hi guys, I am creating a spreadsheet for the sports event for the school.

I have used conditional formatting across my sheets for the house group to colour code it. (ash - red, Oak - green, Willow - Blue, Elm - Yellow), (I am getting the student's house group using vlookup function from their name. But I have a slight problem because whenever there is a student containing "Ash' e.g. Ashley, I will get their name colour code it as well which is not the thing I am looking for.

In addition, in order to get the student's name match to the house, I have to use exact same style that is in the database, LASTNAME, Firstname Middlename, I would like to know if there is any way when the list of names will come up as soon as I start typing their name. e.g. like a google search.

Thank you.

Sports Event.JPGSports Day Spreadsheet Beta.xlsm

Change the Conditional format
Format Only Cells with: under Edit rule description as

Cell Value > Equal to > ="Ash"
instead of
Specific Text > Containing > Ash

Edit all the conditional formats as above