conditional formatting & formula

[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

 

[Dingbat]

Forgot to mention using Excel 03

 

[Dingbat]

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

 

[Dingbat]

Still didn't work. the 7 is meant to be above the 10% but I hope you get
what I mean

 

[Dave Peterson]

#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.