highlight formulas
 

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?

highlight formulas
 

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?

highlight formulas
 

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?

highlight formulas
 

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?

highlight formulas
 

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?

highlight formulas
 

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?

highlight formulas
 

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?