I want to be able to highlight a specific cell, and all other cells on the sheet with the same text also get highlighted

Hello all, I've been searching for a solution, but I haven't been able to find it. I keep seeing similar things, but not exactly what I'm looking for.

Basically I have a few columns that have names in them. Sometimes they are repeated in other columns, sometimes not. What I want to be able to do is click any cell in Column A and highlight it eg- John Doe, and then any John Doe's in the other columns also become highlighted. And I want the highlight to stick, I don't want to just click a cell in column A and it temporarily highlights the same text elsewhere. I want to highlight the cell and all other cells with the same text get highlighted and stay highlighted. That way I can continue highlighting cells in Column A, and all the matches in other columns stay highlighted.

Does this make sense and is it possible? Thanks!

EDIT: Specifically, I have a main list of sports player names in column A. And those names could be found in other columns if they're an offensive or defensive player. I've been highlighting each name in column A and then manually finding the names in other columns and highlighting them. I want to be able to highlight the name in Column A and if it's in any other columns it will also get highlighted.