Conditional highlighting of booleans in Apple Numbers

numbers

Is it possible to do conditional highlighting of booleans in Apple Numbers?

I want to highlight TRUE values one way, and FALSE values another, but booleans don't seem to be supported – only numbers, text, dates, durations and blank:

I tried using "Numbers" => "equal to" but it didn't seem to accept my attempt at doing "equal to" FALSE.

I'm currently using Numbers 3.5.3.

One possible, hacky, workaround would be to change them from booleans to strings.

Best Answer

The OP does not specify how TRUE or FALSE are represented in the cell, but as was stated in another answer, using text is rule will work. This also works for checkboxes, they resolve to TRUE and FALSE as well.

Text is TRUE add formatting
Text is FALSE add other formatting

This works for the result of a formula returning the text TRUE or FALSE. If one is using numbers for Booleans, i.e.: 0 or not 0 then use a number rule.

Number is equal to 0 [zero representing FALSE] add formatting
Number is not equal to 0 [in the case of any number is TRUE] other formatting

See screenshots for examples.

Related Solutions

IOS – Is it possible to do conditional formatting in Numbers for iOS

iOS Numbers does not support conditional formatting, and it is removed from the document upon import.

According to http://support.apple.com/kb/HT4648 the following changes are made on iOS (my emphasis):

3D charts are converted to 2D charts. Chart data is retained and editable.

Conditional formatting is removed from imported spreadsheets. Cell content is retained.

Table Categories are removed. Tables remain organized and category names are retained as static text.

Filters are removed.

Conditional IF DATE function

This may or may not be what you are after.

This Assumes you know which cells you will be referencing. And remember this is only an example..

IF(A2<TODAY(),D2,INDEX(D,COUNTA(D) + 1))

enter image description here

Using the IF function.

IF(if-expression,if-true,if-false)

First Compare date value in A2 with Todays date TODAY() as the if-expression

A2<TODAY()

We use the less than symbol < to return a true or false for the expression.

If the expression returns True, then we fill the cell with The cell data in D2

If the expression returns False, then we fill the cell with the last with data in column D

The INDEX function returns the value in the cell located at the intersection of the specified row and column within a collection of cells or from an array returned by an array function.

The COUNTA function returns the number of its arguments that are not empty.

It is bets you look up in the Functions panel for a fuller explanation on all the functions.

Once you have set up the first row use the drag handle to drag the formula cell down to the other rows you want it on.

enter image description here

They will auto adjust to the correct cell references.

enter image description here

Notes:

At time of this posting the date was 6 September 2014
You will need to find a way of dealing with Blank cells in the data column. If a blank cell is found it will throw the results. You should find a resolve with a google search. It will be the COUNTA function that you need to look at.

Best Answer

See screenshots for examples.

Related Solutions

IOS – Is it possible to do conditional formatting in Numbers for iOS

Conditional IF DATE function

Related Question