Highlight highest value in row

[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

 

[Bob Phillips]

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)

 

[GerryGerry]

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.

 

[MartinW]

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

 

[GerryGerry]

Thanks Martin, that worked a treat

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

 

[Guest]

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

 

[asma waqar]

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!!

 

[asma waqar]

I just got it!!
This is the formula:

=A1=MAX(A:A)

Submitted via EggHeadCafe
Microsoft .NET DataBase Access For Beginners
http://www.eggheadcafe.com/training...Server-Oracle-DB2-Informix-Query-Samples.aspx