Help please... in student's progress tracking excel sheet

I have attached an Excel sheet here. I want a formula which would highlight student’s name, comparing his last three scores, if the score goes from low to high and them back to low (Low-High-Low). The Excel basically has 3 different columns, Students, Score, and Date of Entry. The formula should also check if the student’s score has fallen in the latest date of entry. If one of the columns indicates if the student meets these specific criteria by saying Yes that would help me a great deal. Thank you in advance for your help!