Excel 2003: Conditional Formatting

The ticks indicate the suitability of resources for each Key Stage.

Resource

KS3

KS4

KS5

Click Here

Walkthrough 1: Setting up colours

This worksheet introduces students to using conditional formatting.

It provides a set of step-by-step instructions with numerous screenprints to provide support to students.

 
 
tick
tick

download file

Task

Walkthrough 2

This worksheet provides an alternative introduction to the one above. It can also be used to provide an extra practice task.

Again, a set of step-by-step instructions and screen prints are given to support students.

 

tick
tick
download file

Task

 

 

 

 

 

 

 

 

Copyright © www.teach-ict.com