You need to use conditional formatting.

Go to Data--Conditional Formatting, then go throught he dialog box you're
presented with.

Basically: select the range in question, select as your condition "Formula
is" and in the text box right the formula =MAX([your range]) and select the
color you want for highlighting. The max value in that range will be
highlighted.

Dave
--
Brevity is the soul of wit.


"Bishop8910" wrote:

I need a formula to highlight a cell if a cells is the highest in a range of
values.