Thank you, unfortunately i see differenent colors, however the macro to enable the colors when "Clicked" is missing or i am not able to see.
Sorry, didn't mean to upload the file with all the colors.
Try this file Copy of Example_data_relation 2-2.xls
When you click on "Badminton", "BMX", "Rugby", or "Boxing", it will then color the next cell you click with the same color, until you click back on original cell.
Example: (1) Click BMX, (2) Change Cell color, (3) Click G15, (4) Click BMX, (5) Click C6, (6) Click D10, (7) Click BMX to turn off color change.
Then tell me how close we are.