Highlight highest value in row

  • Thread starter Thread starter GerryGerry
  • Start date Start date
G

GerryGerry

I have a sheet with 10 columns and several hundred rows. How do I (in Excel
2007) highlight the highest value in each row. I know I can apply
conditional formatting to each row individually but this would take far to
long and is impractical. Any help would be greatly appreciated.

Gerry
 
Select the whole column, and in CF change Condition 1 to Formula Is and a
formula of

=MAX(A:A)


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
I could not get this to work at all. perhaps I should explain a little more.

My sheet looks like this (7 cols and first 3 rows):

1,4,6,7,8,5,9
7,4,5,3,7,8,2
5,7,3,4,6,2,1

ect

I want to know the easiest way of highlighting the 9 from the 1st row, the 8
from the second and the 7 from the third i.e.the highest value in each row.
 
Hi Gerry,

Assuming your data is in A1 to J600.
Select all your data with A1 the active cell
Set Conditional Formatting to formula is =A1=MAX($A1:$J1)

HTH
Martin
 
Thanks Martin, that worked a treat
MartinW said:
Hi Gerry,

Assuming your data is in A1 to J600.
Select all your data with A1 the active cell
Set Conditional Formatting to formula is =A1=MAX($A1:$J1)

HTH
Martin
Click to expand...
 
Select A1 and do Format > ConditionalFormat, and set the conditions for Cell
Value equals, =MAX($A1:$G1), and set your formatting..........then use the
FormatPainter little paintbrush in the upper toolbar to copy the formatting
over to the rest of the cells in the range of interest.

Vaya con Dios,
Chuck, CABGx3
 
Martin, I am tried to do the exact same thing, but in columns, rather than rows. I want to highlight the highest value in each column. I am using excel 2007, so the conditional formatting is a little different. I have tried using the rule "Format where the formula is true" =A1=MAX($A1:$A5)
applies to =$A$1:$C$5

Obviously it is highlighting just the one highest value in column A. Not sure how to go about this.
Help!!
 
Back
Top