With the iWork 2013 update, I can no longer figure out how to make conditional formatting based on a check box, in Numbers. Setting the conditional formatting trigger text to TRUE/FALSE or value to 1/0 has no effect. Have they removed this possibility or am I missing something obvious? Thanks!
iMac, OS X Mavericks (10.9), 2011, quad i7 3,4Ghz, 8Gb RAM
Hi David,
Conditional Formatting (now called Conditional Highlighting in Numbers 3) is more powerful than in Numbers '09.
What are you trying to do?
A screen shot will help (a picture paints a thousand words).
Regards,
Ian.
It is simple, really, I just can't figure out how to do it. 🙂
Hi David,
Just second guessing...
Regards,
Ian.
Hi David,
Our replies crossed in the post 🙂.
Select all the Body Cells in that column (double click on the column letter).
Format Panel > Cell > Conditional Highlighting
Regards,
Ian
Ah, now I understand why I couldn't get it to work. Turns out that if you use a non-english interface, then TRUE/FALSE is also localized! Well, that sure is annoying.. The same goes for formulas, so I'm having a 'fun time' trying to figure out the translated equivalents of the english terms one use in daily speak.
David Munch wrote:
Ah, now I understand why I couldn't get it to work. Turns out that if you use a non-english interface, then TRUE/FALSE is also localized! Well, that sure is annoying.. The same goes for formulas, so I'm having a 'fun time' trying to figure out the translated equivalents of the english terms one use in daily speak.
Hi David,
Thanks for the green tick and feedback.
For your next trick, here is a method that uses the worldwide language of pictures.
Format Panel > Cell > Conditional Highlighting > Add a Rule > Text is... > click on the Cell Reference icon (see screenshot) > Click on Cell B1 (a Checkbox)
No need for TRUE/FALSE in any language.
Regards,
Ian.
Number 3.0 Conditional formatting with check box?
