Highlight cells conditionally in Keynote on Apple Vision Pro

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

  1. Select one or more cells.

  2. Tap the Format button in the navigation bar at the top of the window, tap Cell, then tap Add Conditional Highlighting.

  3. Tap a type of rule (for example, if your cell value will be a number, tap Numbers), then tap a rule.

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

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

  6. 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 pinch and drag the Reorder button 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.

  1. Select the cell with the rule you want to repeat and the cells you want to add the rule to.

  2. Tap the Format button in the navigation bar at the top of the window, then tap Cell.

  3. Below Conditional Highlighting, tap Combine Rules.

Delete a highlighting rule

  1. Select the cells with the rules you want to delete.

  2. Tap the Format button in the navigation bar at the top of the window, then tap Cell.

  3. Below Conditional Highlighting, swipe left on the rule you want to delete, then tap Delete.

Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.