A1:J1 is 10 columns!

Suppose the range of 6 cells is A1:F1

Select that range, A1:F1
Goto the menu FormatConditional Formatting
Condition 1
Formula Is: =AND(ISNUMBER(A1),A1=MIN($A1:$F1))
Click the Format button
Select the desired style(s)
OK
Click Add
Condition 2
Formula Is: =AND(ISNUMBER(A1),A1=MAX($A1:$F1))
Click the Format button
Select the desired style(s)
OK out

Note: if there are duplicate min/max all instances will be formatted.

Biff

"
osoft.com wrote in
message ...
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?