I have excel sheet, which has value stored as price in "D" column

now, I want to highlight particular cell in column "D" which satisfies below 2 conditions

1 XFB9<=0.02
2 which cell has highest value among cells that has fulfilled above condition (column "D")

issue I find here in writing formula is, to define range Because, how do I define range to get highest value from that cell which fulfills no. 1 condition?, because it varies time to time

I have written following formula in conditional formatting for no. 1 condition

=XFB9<=0.02
Kindly help with your solution on this issue, any help highly appriciated.