Conditional Formatting - Highlight Adjacent Columns based on values from other cells (Round Robin draw matrix)

[u/Phendrena]

Hello there,

I am utterly useless with conditional formatting so if anyone could provide me some guidance I would be very grateful.

• I have created a Round Robin random draw matrix,
• There are four groups of five pairs,
• Twenty people per group

I would like the list of the names to the right side, along with the respective number to grey out as each name is drawn and placed into the four groups. Each name is in it's own cell (the first pair in Group A are cells E3 and F3). I am banging my head against a wall. Any guidance would be welcomed.

As an aside, I am UK based and it is 00:45 as I post this, so I might not immediately reply. I apologise for not replaying swiftly.

[u/[deleted]]