Ask Different is a question and answer site for power users of Apple hardware and software. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
up vote 2 down vote accepted

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

According to 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.

share|improve this answer

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.

share|improve this answer

Yes it is possible. See this and this.

share|improve this answer
Both of those refer to Mac iWork, not iOS. – dlanod Sep 2 '12 at 10:16
Oops! Clearly didn't read carefully enough. – D Raymond Sep 2 '12 at 20:12
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. – jherran Feb 10 '15 at 20:40

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.