Is it possible to do conditional formatting in Numbers for iOS? I'd just like to change the text or background colour depending on the cell's contents.

3 Answers 3


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.


The most recent version of numbers on Mac supports conditional formating rules. The current version of iOS numbers does support conditional formating, but only shows UI for simple rules (like turning a number red when it's negative)

To access these, select some cells, then tap the format button (paintbrush), tap format, and then the more info/(i) button next to one of the options. From there you can chose some simple preset options.

If you want anything more complex, use numbers for Mac.



Yes it is possible. See this and this.

  • Both of those refer to Mac iWork, not iOS.
    – dlanod
    Sep 2, 2012 at 10:16
  • Oops! Clearly didn't read carefully enough.
    – D Raymond
    Sep 2, 2012 at 20:12
  • You shouldn't just link to another post. The pages could disappear (as one has in this case) or not accessible to all users (like the other which seems like a Mac only video and I'm on a Work's Windows Machine...)
    – GazB
    Feb 16, 2018 at 14:58

You must log in to answer this question.

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