Select A1:J1 (with A1 active),
then apply these cond format formulas [Conditions 1 and 2]:

=A1=MAX($A1:$J1)
Format for Max

=AND(A1=MIN($A1:$J1),A1<"")
Format for Min
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
" wrote:
I'm using a worksheet where I have 7 columns, of the 7, six of the columns
have scores where I'm using the formula =sum(a1:j1)-max(a1:j1)-min(a1:j1) to
eliminate the high and low and put the total of the remaining four in the 7th
column. My question is, how can I format the cells so that it will highlight
the "high and low" scores that are being eliminated?