Bobs code or Marks should work. Where are you putting the code. It has to go in the worksheet that you have your data in in the OP.

In the VBA editor (Alt + F11) double click the sheet your data is in from the VBA Project pane.

Next in the bigger window on the right where you see (General) click the drop down and change it to Worksheet. This will automatically bring up the Worksheet_Selection Change event. That is where the code goes. Have you tried that?