Highlight lowest value in row via conditional formating

[mstillwago]

How do I use conditional formating to highlight the lowest (or highest) value in a row of numbers?

Thanks.

 

[NateO]

Howdy mstillwago, welcome to the board.

Condition 1:

cell value is equal to =MAX(row#:row#)

Condition 2:

cell value is equal to =min(row#:row#)

Hope this helps.

Edit: apply the format to the entire row, you can select the row while doing this.
_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue"> Oliver</font></font></font>
This message was edited by NateO on 2002-12-04 17:50

 

[lenze]

Say row 3 Try something like
Formula is
=A3=Max(3:3)

 

[maxflia10]

=AND(A1=MIN(A:A),COUNTIF(A:A,A1)=1)
will highlight only the lowest number, if there is a dupe number i.e. two 1's, it will not highlight

Forgot to mention, got this from Mark W.
This message was edited by maxflia10 on 2002-12-04 17:49

 

[EdE]

First of All, Welcome to the Board!

Under conditional format, change the drop down to formula is.
For condition 1, type the formula
=if(a3=max($A$3:$A$24),1,0) then format
For condition 2, type the formula
=if(a3=min($a$3:$a$24),1,0)

Make sure you put the range as absolute reference otherwise multiple highlights will showup.

HTH~
EdE