Google-sheets – Max value conditional formatting rule not working in Google Sheets

conditional formattingformulasgoogle sheets

I want the max value in Column B to show up. I put in this formula but it's not working. What am I doing wrong?

enter image description here

Here is the table

enter image description here

Best Answer

custom formula:

=B15=MAX(B$15:B20)

5