I have a spreadsheet set up that tracks testing scores for
candidates/employees.

I would like to use conditional formatting so I can visually see who has the
highest score and the lowest score

However, I've tried to do conditional formatting and to enter in =MAX (and
then my range) but the conditional formatting applies the color change to all
cells.

Does anyone know how to fix this?