{"text_format":"3","workbook":"xls","n_sheets":5,"sheets":["four square puzzle","nursery rhyme puzzle","conditional formatting","format cell alignment and color","planning grid"],"not_rendered":{"images":2,"external_links":1,"comments":11},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"four square puzzle","index":0,"n_rows":7,"n_cols":8,"rows_kept":7,"merged":[[6,1,6,4]],"flags":["formulas_cached_only"]}
[]
[{"$nulls":7},"Type one letter"]
[{"$nulls":7},"in each box"]
[]
[{"$nulls":7},"Incorrect letters"]
[{"$nulls":7},"turn red."]
[null,"Clues can be seen where the \nred triangles are located"]

{"sheet":"nursery rhyme puzzle","index":1,"n_rows":7,"n_cols":18,"rows_kept":7,"merged":[[0,2,0,14]],"flags":["formulas_cached_only"]}
[null,null,"Nursery Rhyme Puzzle"]
[]
[{"$nulls":17},"Type one letter"]
[{"$nulls":17},"in each box"]
[]
[{"$nulls":17},"Incorrect letters"]
[{"$nulls":17},"turn red."]

{"sheet":"conditional formatting","index":2,"n_rows":55,"n_cols":1,"rows_kept":55,"flags":["formulas_cached_only"]}
["Conditional formatting is used on the puzzle to indicate correct or incorrect letters in a cell."]
["To illustrate conditional formatting look at the red box below this line. If you type the letter A,"]
["lower case or capital, the letter will turn blue when you press enter. Try any other letter and"]
["the letter will turn red after you press enter. Look at the blue box. Determine which letter goes there."]
[]
[]
["If you need a clue, click on the blue box, select the Format menu then select Conditional Formatting to see."]
["The image below shows how I formatted the red box. Select the Format button to see color choices"]
{"$rows_empty":16}
["OK, now it's your turn. In the green box, set conditional formatting so that X is the proper choice"]
[]
["Need help? Send email to bylesb@internet4classrooms.com and ask."]
[]
["Ready for the next step?"]
["click on the arrow"]
[]
[]
["Shortcut!!!"]
["To save some steps, after formatting one letter, use format painter to copy the "]
["formatting of the letter and transfer it to all other letters. I know, I know, be patient!"]
["Click on a red letter (not incorrect, but the formatting is wrong). Next click on "]
["the Format menu and select Conditional formatting."]
{"$rows_empty":16}
["See it? All you do is highlight the wrong letter and change it to the correct letter. Be sure to leave the"]
["quotation marks."]

{"sheet":"format cell alignment and color","index":3,"n_rows":29,"n_cols":8,"rows_kept":29,"flags":["formulas_cached_only"]}
["The cells on the conditional formatting sheet were set, by default, so the letter are displayed"]
["in the bottom left corner of the cell, but on the crossword puzzle page the letters are in the"]
["center of the cell. That is done from the format menu also. For example, type B in the orange box"]
[null,"B"]
["The letter should be green, unless you typed something other than B. But the letter should also be in the"]
["middle of the box. For a crossword puzzle that alignment looks more pleasing. To format alignment"]
["click on a cell, select Format, then select Cells, then the Alignment tab. I selected"]
["center from both the Horizontal and Vertical boxes. Ready for your assignment? In the purple box"]
["set conditional formatting so that the letter X is displayed in green, and any other letter is displayed in red."]
["Also set formatting so that the letter will be centered vertically and horizontally, and make the font 14 pt "]
[]
[{"$nulls":6},"X","Does Yours look\nlike this?"]
[]
["One more skill will make your crossword puzzle easier to create. You can select several cells at once and fill all of them with a color"]
["That is done by holding down the Ctrl key and clicking on the cells to be highlighted one at a time. To practice that skill, "]
["select all of the blue boxes below and fill them with black. Do not fill any other cells with black, just the ones outlined in blue."]
{"$rows_empty":9}
["Congratulations! You are ready to start on your own crossword puzzle. The next step is a pencil and paper step."]
["Make a list of the words you want on your puzzle. Include more words that you will probably put in your puzzle."]
["Now, print several sheets of the grid paper in this workbook, and try to make the words fit. Plan on paper first"]
["then open Excel and start your puzzle. If youj wish, use the grid sheet to make your puzzle."]

{"sheet":"planning grid","index":4,"n_rows":20,"n_cols":24,"rows_kept":20,"flags":["formulas_cached_only"]}
{"$rows_empty":19}
[{"$nulls":23},"."]