Results 1 to 5 of 5

Highlight lowest value in row via conditional formating

This is a discussion on Highlight lowest value in row via conditional formating within the Excel Questions forums, part of the Question Forums category; How do I use conditional formating to highlight the lowest (or highest) value in a row of numbers? Thanks....

  1. #1
    New Member
    Join Date
    Dec 2002
    Posts
    1

    Default

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

    Thanks.

  2. #2
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,702

    Default

    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, Nate Oliver

    [ This Message was edited by: NateO on 2002-12-04 17:50 ]

  3. #3
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690

    Default

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

  4. #4
    Board Regular
    Join Date
    May 2002
    Posts
    890

    Default

    =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 ]

  5. #5
    EdE
    EdE is offline
    Board Regular
    Join Date
    Apr 2002
    Location
    A Mile High!!
    Posts
    231

    Default

    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

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com