I would like someone to help me write the VB Code / Macro for this
situation of conditional formatting:

I am running the March Madness pool, and would and like to have this
happen:

When I hightlite the winning team yellow, I want the winning team to be
spit out from that bracket to another cell.

If anyone can tell me the VB code for this, I'd appreciate it.