MAKING IT INTERACTIVE
Next, you need to set the conditions that will let students know whether their answers are right or wrong. In Excel, a condition tells the program that if a certain value is typed in a cell, the formatting for that cell should change.
So students will know whether an answer in the crossword puzzle is right or wrong, each correctly typed letter will be green and each incorrectly typed letter will be red. To set those conditions:
- Click cell A3.
- Click Format in the menu bar and select Conditional Formatting.
- Click Add. You'll now see two menus, Condition 1 and Condition
2.
- For Condition 1, in the drop-down menu that says "between,"
select "equal to" instead, and type the letter W in the empty
box next to it. Click Format, change the color to green, and click
OK.
- For Condition 2, in the drop-down menu that says "between,"
select "not equal to" instead, and type the letter W in the empty
box. Click Format, change the color to red, and click OK twice.
The "W" in cell A3 now should be green! Delete the W and type
any letter in cell A3. Is the new letter red? Then you formatted
the conditions correctly!
Click cell B3, click Format >Conditional Formatting, and follow the
five steps above, this time typing the letter A in the empty boxes.
Repeat the five steps for every letter in every word of your puzzle.
That will take a while at first, but you'll soon get into the rhythm
of it!
When you finish the conditional formatting, delete all the text from the puzzle. The puzzle now should be blank, except for the colored background and the red triangles in the corner of the clue cells.
Raise your right hand, bend your right elbow, and pat your left shoulder blade
with your right hand. You did it!
Next: Create a crossword puzzle template.
|