Highlight Rows in a table with certain condition

Hi all,

I am grappling with this for a little while now but have not been able to figure out a solution yet.
I have a table of values and depending on the highest value in a column, I would want the whole row to be highlighted and similarly smallest value highlight as well.

Please take a look @ the data below of the table and see if my problem statement makes sense.
In this table, I would want the specific row to be highlighted in a specific color based on highest Win% value
and same for lowest Win % also.

Can you please help?

Thank you so much

Pair Proposed Won Lost Win % Lost %
B & R 4 3 1 75% 25%
R & S 6 4 2 67% 33%
B & S 6 2 4 33% 67%
A & D 8 2 6 25% 75%
A & R 5 5 0 100% 0%
B & D 5 1 4 20% 80%
D & R 2 2 0 100% 0%
D & S 2 0 2 0% 100%
A & B 3 2 1 67% 33%
A & S 1 0 1 0% 100%