Highlight cells conditionally in Pages on iPad

You can have Pages change the appearance of a table cell or its text when the value in the cell meets certain conditions. For example, you can make cells turn red if they contain a negative number. To change the look of a cell based on its cell value, create a conditional highlighting rule.

Add a highlighting rule

Go to the Pages app on your iPad.
Open a document with a table, then select one or more cells.
Tap , tap Cell, then tap Add Conditional Highlighting.
Tap a type of rule (for example, if your cell value is a number, tap Numbers), then tap a rule.
Enter values for the rule.
For example, if you selected the rule “Date is after,” enter a date that the date in the cell must come after.
Tap a text style, such as bold or italic, or a cell fill, such as red or green.
You can choose Custom Style to choose your own font color, font style, and cell fill.
Tap .

Note: If a cell matches multiple rules, its look changes according to the first rule in the list. To reorder rules, tap Edit, then drag next to the rule name. Tap Done.

Repeat a highlighting rule

After you add a conditional highlighting rule to a cell, you can apply that rule to other cells.

Go to the Pages app on your iPad.
Open a document with a table, then select the cell with the rule you want to repeat and the cells you want to add the rule to.
Tap , then tap Cell.
Below Conditional Highlighting, tap Combine Rules.

Delete a highlighting rule

Go to the Pages app on your iPad.
Open a document with a table, then select the cells with the rules you want to delete.
Tap , then tap Cell.
Below Conditional Highlighting, swipe left on the rule you want to delete, then tap Delete.

Noderīgs?

Pages User Guide for iPad

Highlight cells conditionally in Pages on iPad

Add a highlighting rule

Repeat a highlighting rule

Delete a highlighting rule