Conditional format if cell is between percentage value

Question

i need to highlight row if a value falls into certain percentage value and so on. B2 contains a percentage A5:A9 has different percentage value if any cell between A5;A9 falls under B2 entire row should highlight.

check the link below file link here

Answer 1

Added formula to your sheet here:

=$A5=xlookup($B$2,$A:$A,$A:$A,,-1)