highlight formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 Format>Conditional 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

"(e-mail address removed)"
 
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


„[email protected]†ezt írta:
 
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
 
Hi, Biff,

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

Regards,
Stefi


„Biff†ezt írta:
 
Back
Top