iWork
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
by SGIII,Solvedanswer
Mac OS X
One way would be to calculate the MIN in a cell in a Footer Row, select the cells in the of the column and apply Conditional Highlighting like this:
You have to click the address token first, then select the comparison cell, here A8, then make sure to preserve row and column.
The formula in A8 of the example is =MIN(A).
The result is a bolded 2 (not shown in screenshots).
SG
Posted on Sep 1, 2016 12:25 PM

