I HAVE A LIST OF TRACK MEET EVENTS (25 COLUMNS) AND A LIST OF PARTICIPANTS
(500 ROWS) I HAVE A CHECK MARK IN EACH COLUMN FOR THE EVENTS THEY HAVE
ENTERED. MANY HAVE ENTERED MULTIPLE EVENTS WITH 3 BEING THE MAXIMUM ALLOWABLE
NUMBER OF EVENTS ALLOWED TO BE ENTERED SO IF A PARTICIPANT ENTERS MORE THAN 3
I NEED TO TURN THE ADDITIONAL EVENTS RED BUT STILL LIST THEM. IT IS OK TO
LIST THEM ON THE SAME SPREADSHEET I JUST NEED TO MAKE IT EASIER TO SEE WHAT
EVENTS EACH PARTICIPANT IS REGISTERED IN. A CONSOLIDATED VIEW IF YOU WILL. I
DO NOT NEED TO LIST PARTICIPANTS THAT HAVE NOT SIGNED UP FOR AN EVENT IN THIS
VIEW BUT IF IT IS EASIER IT DOES NOT MATTER. THANKS FOR ANY HELP WITH THIS.


I NEED TO OUTPUT TO A LIST OF EVENTS EACH PARTICIPANT IS ENTERED IN.