How do yo highlight highest and lowest values

Question

Level 1

5 points

How do yo highlight highest and lowest values

I Excel you can use conditional formatting to highlight the lowest or highest number in a row or column.

As a new user of iWorks I was wondering if this can be done with the conditional formatting feature within Numbers?

MBP 17", Mac OS X (10.5.6)

Posted on Mar 10, 2009 3:28 AM

Reply

Answer 1

Badunit

Level 7

30,714 points

Mar 10, 2009 6:52 AM in response to Thraxmanius

Not directly. The conditional formatting doesn't allow any types of formulas, only comparisons to specific cells. Create a cell somewhere that uses the MAX or MIN function to determine the highest/lowest number in your column or row. Then your conditional format will be "if equal to" that cell.

Reply