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?

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?

A:J is 10 columns, not 6. If you have 6 columns of scores starting with A,
then your range is A:F, the 7th summary column is G.
Use conditional formatting for range A1:F1!

Select this range
Format/Conditional formatting/Choose Formula as condition/Enter this formula:

=OR(A1=MAX($A$1:$F$1),A1=MIN($A$1:$F$1))

Choose a pattern

Regards,
Stefi


€� ezt Ã*rta:

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?

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?

That'll work but both numbers will be the same format.

Biff

"Stefi" wrote in message
...
A:J is 10 columns, not 6. If you have 6 columns of scores starting with A,
then your range is A:F, the 7th summary column is G.
Use conditional formatting for range A1:F1!

Select this range
Format/Conditional formatting/Choose Formula as condition/Enter this
formula:

=OR(A1=MAX($A$1:$F$1),A1=MIN($A$1:$F$1))

Choose a pattern

Regards,
Stefi


" ezt írta:

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?

See http://xldynamic.com/source/xld.CF.html#top3

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"
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?

Hi, Biff,

Yes, but the post didn't contain this requirement, just "highlight" them!

Regards,
Stefi


€žBiff€� ezt Ã*rta:

That'll work but both numbers will be the same format.

Biff

"Stefi" wrote in message
...
A:J is 10 columns, not 6. If you have 6 columns of scores starting with A,
then your range is A:F, the 7th summary column is G.
Use conditional formatting for range A1:F1!

Select this range
Format/Conditional formatting/Choose Formula as condition/Enter this
formula:

=OR(A1=MAX($A$1:$F$1),A1=MIN($A$1:$F$1))

Choose a pattern

Regards,
Stefi


" ezt Ã*rta:

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?