conditional formatting & formula

  • Thread starter Thread starter Dingbat
  • Start date Start date
D

Dingbat

Hello
I'm working on a spreadsheet and would like to highlight the highest value
across.
i.e.

Name 1 2 3 4 5 6
7
Mary 1% 2% 2% 25% 45% 15% 10%

These are the student's probabilities to achieve grades 1 to 7
I'd like a conditional Format to highlight the highest probability, in this
case 45%
I would also like a column on the right of 7 to show the grade that
corresponds with the highest probability in this case 5. which may have to
be a formula

Appreciate any help on this
Thank you
 
the columns moved after I sent the message
It's meant to be like this

Name 1 2 3 4 5 6
7
Mary 1% 2% 2% 25% 45% 15% 10%

Hope it shows better this time
 
#1. You can use format|conditional formatting to highlight the largest value in
the range.

Say your percentages are in B2:Fxxx
Select that range
With B2 the activecell, Format|conditional formatting
Formula is:
=B2=MAX($B2:$F2)
And give it a nice format.

The $B and $F will mean that these columns won't change. But excel will be
smart enough to adjust the row number -- just like when you copy a formula down
a column.

#2. In G2:
=index($b$1:$g$1,match(max($b2:$g2),$b2:$g2,0))

======
Actually, the formatting will highlight all the cells in that row with the
highest percentage. But the formula will only return the first match for that
highest percentage.
 
Back
Top