Update:
After doing a few playthroughs to try and understand now what is wrong exactly, when I am on the first colour (red) it works perfectly, it deletes rows as it should, if I am matching either of the two other colours (blue or green) of LCA or Player 1 it does not work at all. I am really baffled by that as the same function above works perfectly in the same kind of way, only difference is, the second if function for removing the rows says 'and' twice, is this the problem?