Highlight cells conditionally in Pages on iPad

Table of Contents

Welcome
What’s new
- Keyboard shortcuts
- Keyboard shortcut symbols
Copyright

, tap Cell, then tap Add Conditional Highlighting.

Tap a type of rule (for example, if your cell value will be 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 Done.

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 , then tap Cell.

Below Conditional Highlighting, tap Combine Rules.

Delete a highlighting rule

Go to the Pages app Alphabetize or sort table data in Pages on iPad

Helpful?

Pages User Guide for iPad

Delete a highlighting rule