If your range is B2:x99, you could:
Select the range
with B2 the activecell
format|conditional formatting
formula is:
=b2=min($b$2:$x$99)

and
formula is:
=b2=max($b$2:$x$99)

Those $ signs are important.

MMangen wrote:

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?

--

Dave Peterson