Conditional formatiing based on cel "Value"

I'm trying to make a sheet for a game to keep score. On this game every episode there will be a loser who has to leave the game. I want it so that when I Type the name of the loser in a cel apart from the table, the table (column) will turn red completely. Now I have figured this part out.

Now since there are 10 episodes, i want it so that the conditional formatting also goes to the next table (episode 2 table) and so on, so that i dont have to have 10 conditional formats per column in episode 10. Screenshot 2024-03-27 173306.png

Hope the screenshot helps. And hope you guys can help too. Thanks in advance.

Welcome to the forum.

There is no Excel 2024 yet - what do you have?

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.