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