Hi,
you need conditional formatting....Select your range, goto
FormatConditional Formatting...in the file menu then (assuming your
range is A1:A10) enter this

Formula Is = =A1=MAX($A$1:$A$10) and set the format you want.

Repeat with MIN for minimum value...
Hth,
OJ