If cell color is x copy cell content

[twrtleduck]

I have groups of 3 for a table tennis tournament. If they win two they go to group one and win one, loss one they go to group two and if they loss both they go to group three. I want to be able to give their name a color and it populates them in to the correct group.

[jeffreybrown]

You will need VBA for that and it might be more complicated than it's worth.

Why not just use a formula! In column C, put a 1 next to Bob, Amy, and Liz and so forth...

Then in E4 use...

=INDEX($B$3:$B$13,SMALL(IF($C$3:$C$13=1,ROW($B$3:$B$13)-ROW($B$3)+1),ROWS($E$4:E4)))

Commit with Ctrl + Shift + Enter

Repeat the formula in G4 and I4 changing the part in Red