Highlight Top and Bottom Performer using Conditional Formatting

Highlight the top and bottom performer using conditional formatting in Excel: a drop-down in C1 plus two AND, MAX and MIN formula rules colour the whole row. Free practice file.