Keynote

Highlight cells conditionally in Keynote on iPad

You can have Keynote change the appearance of a 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

Select one or more cells.
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.

Helpful?

Keynote User Guide for iPad

Highlight cells conditionally in Keynote on iPad

Add a highlighting rule

Repeat a highlighting rule

Delete a highlighting rule