Keynote User Guide for iPad
- Welcome
-
- Intro to Keynote
- Intro to images, graphs and other objects
- Create your first presentation
- Open a presentation
- Save and name a presentation
- Find a presentation
- Print a presentation
- Copy text and objects between apps
- Basic touch screen gestures
- Use Apple Pencil with Keynote
- Create a presentation using VoiceOver
- Copyright
Highlight cells conditionally in Keynote on iPad
You can make Keynote change the appearance of a cell or its text when the value in the cell meets certain criteria. 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
Tap
, 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 colour, 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 
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 too.
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
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.