highest value

J

Jay

Hi everybody. This is my problem: I've got some values in a row, how
can I make excel highlight the highest value automatically? Thanx in
advance.
Jay
 
K

Ken Johnson

Hi Jay,

Use Conditional formatting.
Say the row is row 2, select row 2 then go Format>Conditional
formatting then on the dialog change "Value Is" to "Formula Is" and use
the following formula...

=AND(A2<>"",A2=MAX(2:2))

Then set the appropriate formatting to highlight the maximum.

If you don't want the whole row affected, say only from the 2nd (B) to
the 10th (J) columns, then only select those cells and change the
formula to...

=AND(B2<>"",B2=MAX($B2:$J2))

Ken Johnson
 
Top