Highlighting Only a Single Row When There Are Multiple Rows With the Same Value

[NoDayButToday]

I have a table where I'm tracking my weekly weight, body fat, and BMI measurements. I used conditional formatting to highlight the row containing my highest weight in red and the row containing my lowest weight in yellow. However, I've recently run into a problem where I have the same weight as previously recorded a few months ago, so now I have two rows highlighted yellow. How can I make it to where only the row containing my most recent lowest weight is highlighted in yellow?

Formulas used:
=$B1=MIN($B:$B)
=$B1=MAX($B:$B)

 

[dreid1011]

If you're set on full column references, then give these a try:

=AND($A1=LARGE(IF($B:$B=MIN($B:$B),$A:$A,""),1),$B1=MIN($B:$B))

=AND($A1=LARGE(IF($B:$B=MAX($B:$B),$A:$A,""),1),$B1=MAX($B:$B))

 

[NoDayButToday]

Thank you! This worked perfectly.

 

[dreid1011]

You're welcome, and happy to help.