Adding more rules for more colours

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. A colour key says 0 = white, 1 = black and 2 = red. How many conditional formatting rules does the grid need?

A Three rules, one for each number

B One rule that colours every number

2. You made a rule for 1 (black). Now you want the number 2 to turn red. What do you do?

A Change the rule for 1 so it fills red

B Add a new rule: cells equal to 2 get red fill

3. Which rule matches the colour key 3 = green?

A Format cells equal to 3 with a green fill

B Format cells equal to 3 with a red fill

4. A grid has only 0s, 1s and 2s. You have rules for 0 and 1 only. What happens to the cells with a 2?

A They stay uncoloured, because no rule matches 2

B They turn the same colour as the 1s

5. A rule says 'cells equal to 5 turn blue', but the key says 4 = blue. Which fix is right?

A Change the key so 4 = red

B Change the rule to cells equal to 4

Match the Pairs

Draw a line connecting each item on the left to its match on the right.

Left column		Right column
1Add new rule		ARule 2 uses the number 1 again instead of 2, so the cells holding 2 never turn red. It should be =2.
2Cell value = 2 → fill green		BRule 1: =0 white \| Rule 2: =1 black \| Rule 3: =2 red
3The colour key says 0 is white, 1 is black and 2 is red, so the grid needs three rules, one for each number.		CA rule that colours every cell holding the number 2 green, and no other cells.
4Adding a rule for the number 3 lets the cells holding 3 show a new colour, such as blue, without changing the other colours.		DThe rule colours cells holding 2 and also 3, 4 and higher, not just the number 2. It should be Cell value = 2.
5Rule: Cell value > 1 → fill red (key says only 2 is red)		EAdd new rule: Cell value = 3 → fill blue
6Rule 1: =1 black \| Rule 2: =1 red (key says 2 is red)		FMakes one more conditional formatting rule, so one more number can be linked to its own colour.

Definitions

Add new rule

Fill in the Blanks

Complete each line of code by filling in the missing parts.

Colour key: 0 = white, 1 = black, 2 = red Rule 3: If cell equals _, fill red

Key: 1 = blue, 2 = green, 3 = yellow Rule 2: If cell equals 2, fill _____

Key: 1 = blue, 2 = green, 3 = yellow Rule 1 fills blue, Rule 2 fills green Rule _ fills yellow

Key: 4 = orange Broken: If cell equals 5, fill orange Fixed: If cell equals _, fill orange

Grid numbers: 0, 1, 2, 3 One rule for each number So we need _ rules

Spot the Error

Shade in the letter of the line that contains an error.

Question 1

A Colour key: 1=red, 2=blue

B Rule 1: cell = 1 -> blue

C Rule 2: cell = 2 -> blue

Question 2

A Key: 1=red 2=blue 2=green

B Rule 1: cell = 1 -> red

C Rule 2: cell = 2 -> blue

D Rule 3: cell = 3 -> green

Question 3

A Key: 1=red 2=blue 3=green

B Rule 1: cell = 1 -> red

C Rule 2: cell = 2 -> blue

D Rule 3: cell = 2 -> green

Question 4

A Range: A1:E5

B Rule 1: cell = 1 -> black

C Rule 2: cell = 2 -> red

D Rule 3: cell > 3 -> blue

Question 5

A Key: 0=white 1=grey 2=black

B Rule 1: cell = 0 -> white

C Rule 2: cell = 3 -> grey

D Rule 3: cell = 2 -> black

Answer Key

Adding more rules for more colours

Section A: Quick Questions

A — Three rules, one for each number

B — Add a new rule: cells equal to 2 get red fill

A — Format cells equal to 3 with a green fill

A — They stay uncoloured, because no rule matches 2

B — Change the rule to cells equal to 4

Section B: Match the Pairs

Add new rule → Makes one more conditional formatting rule, so one more number can be linked to its own colour.

Cell value = 2 → fill green → A rule that colours every cell holding the number 2 green, and no other cells.

The colour key says 0 is white, 1 is black and 2 is red, so the grid needs three rules, one for each number. → Rule 1: =0 white | Rule 2: =1 black | Rule 3: =2 red

Adding a rule for the number 3 lets the cells holding 3 show a new colour, such as blue, without changing the other colours. → Add new rule: Cell value = 3 → fill blue

Rule: Cell value > 1 → fill red (key says only 2 is red) → The rule colours cells holding 2 and also 3, 4 and higher, not just the number 2. It should be Cell value = 2.

Rule 1: =1 black | Rule 2: =1 red (key says 2 is red) → Rule 2 uses the number 1 again instead of 2, so the cells holding 2 never turn red. It should be =2.

Section C: Definitions

Add new rule — Each extra conditional formatting rule links one more number to one more colour, so one grid of numbers can show many colours.

Section D: Fill in the Blanks

Colour key: 0 = white, 1 = black, 2 = red
Rule 3: If cell equals 2, fill red

Key: 1 = blue, 2 = green, 3 = yellow
Rule 2: If cell equals 2, fill green

Key: 1 = blue, 2 = green, 3 = yellow
Rule 1 fills blue, Rule 2 fills green
Rule 3 fills yellow

Key: 4 = orange
Broken: If cell equals 5, fill orange
Fixed: If cell equals 4, fill orange

Grid numbers: 0, 1, 2, 3
One rule for each number
So we need 4 rules

Section E: Spot the Error

B — The colour key says 1 is red, but this rule colours 1 blue. It should be: Rule 1: cell = 1 -> red.

A — The key gives the number 2 two colours, so number 3 has no colour. The last entry should be 3=green so each number has one colour.

D — Rule 3 should match the number 3, but it matches 2 again, which already has a rule. The 3s would never turn green. It should be: Rule 3: cell = 3 -> green.

D — The > sign colours cells bigger than 3, so the 3s stay uncoloured and the wrong cells change. It should use = : Rule 3: cell = 3 -> blue.

C — The colour key has no number 3. Grey belongs to the number 1, so the rule should be: Rule 2: cell = 1 -> grey.