cody68

Q: How do I highlight min value in a colum?

I need to highlight the lowest value number in each column of my spreadsheet. I'm trying to use the conditional highlight but I can't find a function to work like I need.

MacBook Pro (Retina, 13-inch, Late 2013), iOS 9.3.5

Posted on Sep 1, 2016 11:37 AM

Close

Q: How do I highlight min value in a colum?

  • All replies
  • Helpful answers

  • by SGIII,Solvedanswer

    SGIII SGIII Sep 1, 2016 12:25 PM in response to cody68
    Level 6 (10,627 points)
    Mac OS X
    Sep 1, 2016 12:25 PM in response to cody68

    One way would be to calculate the MIN in a cell in a Footer Row, select the cells in the body of the column and apply Conditional Highlighting like this:

     

    Screen Shot 2016-09-01 at 3.18.40 PM.png

     

     

    You have to click the address token first, then select the comparison cell, here A8, then make sure to preserve row and column.

     

    Screen Shot 2016-09-01 at 3.20.38 PM.png

     

     

    The formula in A8 of the example is =MIN(A).

     

    The result is a bolded 2 (not shown in screenshots).

     

    SG