4

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:

Screenshot

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.

Improve this question
1

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.

Conditional formatting for text

Conditional formatting for numbers

Improve this answer
2

A boolean in Numbers seems to be represented internally as a String already. Setting "text is TRUE" and "text is FALSE" worked for me.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .