Skip to content

Applying conditional formatting to data

Lesson 4 / 6

Lesson video

The video is not available yet.

Lesson slides

not available yet

Lesson details

Lesson outcome

I can use conditional formatting and a range of tools to present data effectively.

Show transcript
Conditional formatting applies a style or format to a cell based on whether a cell matches a certain criteria. Conditional formatting can be applied to specific data in a range of cells. Conditional formatting can be used to highlight or pick out key pieces of data. Spreadsheet tools can be combined to analyse and present data.

Worksheet

not available yet

Quizzes

This quiz is not available yet.

What pupils see

The same lesson as a pupil sees it. You can set any section as work on its own.

  • IntroductionPrepare · Not available
  • Starter quizActivate · Not available
  • Lesson videoLearn · Not available
  • Exit quizCheck · Not available
This content is by Cashar and published under an open licence.