Conditional formating to highlight cells which contain text from other cells

[dlemoel]

Conditional formating to highlight cells which contain text from other cells

Effective I need a player search tool.

To explain, I have a list of football starting line ups for 17 games. When we play the next matches I want to be able to put the 11 names from the days match into the Matchday list which i have created to quickly see when they have played in the previous matches.


so in the cell range A2 - Q22 if there appears the name "Custudio" (as in Cell A27) then all the cells in the range A2 - Q22 should change to yellow if the name appears. I would like to repeat this for different colours with all the Cells in the match day list.

When i change the name in A27.... for example to "Cuņat" then i would need all the cells with Cuņat to appear in yellow


in the FOLLOWING MATCHES I will need to copy and past the next teams information into the excel sheet and be able to quickly type into the matchday list to get the same conditional formatting.