Click on a cell in sheet1 and find matching record on sheet2

I have been lost for day and I'm hoping that you can help.

I have a workbook (attached). I want to click on a score in Column F (Sheet1) and have it do a match between Column B (Customer Name Sheet1) to Column C (Customer Name Sheet2). If it finds a match I want to highlight the row in yellow. If it doesn't find a match I want the message "no record" to pop up in a box. Once I choose another record I want the process to start all over and clear the highlighting from any old record previously highlighted in yellow.

Thanks so much for any help you can provide.