Not a formula, per se, you have to use the feature called Conditional
Formatting.
Highlight the column/area you wish to format, then do Format Conditional
Formatting
then in the pop-up window, for condition 1, set "Cell Value Is" "equal to"
=MAX($A:$A), then click FORMAT and set the desired formatting.
Then click ADD, and for condition 2 set "Cell Value Is" "equal to"
=MIN($A:$A), then click FORMAT and set the desired formatting for that
condition. then click OK and you're done.......however, if you have two or
more cells that equal the MAXIMUM or MINIMUM value they will all be
highlighted.

hth
Vaya con Dios,
Chuck, CABGx3



"Tim" wrote:

Is there a formula to highlight (in a different colour) a only the highest
and the lowest number in one column.
I am not sure if this possible to do in excel 2003.