Highlight Rows in a table with certain condition

[super_duper_guy]

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%

[FDibbins]

It is hard to make out where your data starts and ends, please upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[super_duper_guy]

Thank you so much sir for the prompt response.
Please find attached sample spreadsheet with comments inside on the requirement.

Regards

[Tiger20]

A B C D E F G
2 Pair, Proposed, Won, Lost, Win %, Lost %
3 B & R 4 3 1 75% 25%
4 R & S 6 4 2 67% 33%
5 B & S 6 2 4 33% 67%
6 A & D 8 2 6 25% 75%
7 A & R 5 5 0 100% 0%
8 B & D 5 1 4 20% 80%
9 D & R 2 2 0 100% 0%
10 D & S 2 0 2 0% 100%
11 A & B 3 2 1 67% 33%
12 A & S 1 0 1 0% 100%

Conditional formatting rules
=$F3=MIN($F$3:$F$12)
=$F3=MAX($F$2:$F$12)

[super_duper_guy]

Thank you Tiger, I added these 2 conditional formats in the spreadsheet after selecting the range of cells in the table but somehow it is not highlighting any row.neither max nor min..Should I be doing something differently?

[Tiger20]

Or here is yours rec'd after other

[super_duper_guy]

It works great.Thank you so much Tiger for the help. This is highly appreciated.
This group rocks