Google Sheets Quiz Colour Clue

1. Open a blank Google Sheet and  name your project.

2. Add images or questions.

In this quiz the players have to identify the images rather than answer questions. If you want to write questions in the cells, then do that instead of images.

If you have images that you have ready to add, then do the following:

To change the size of the image, you need to change the size of the row like this:

You can change the width of the rows by doing this:

For you perfectionists out there (like me), this is how you centre the image:

3. Set up the spreadsheet so that the cell changes colour when the answer is correct.

We use a part of Google Spreadsheets called Conditional Formatting. That's just fancy language for setting up the spreadsheet so that IF something is entered THEN something happens as a result of that.

Go to 'Format' then choose 'conditional formatting'.

This is the menu that opens up when you choose conditional formatting:

Add the rules which work for your answers:

You might have to think about adding more than one rule if spellings of a word might be different. (Upper case and lower case letters don;'t matter). You can add as many rules as you like. eg. 

You can change the rules to suit any type of answer using this menu. For a number answer, for example, you would most likely choose 'is equal to' and then type in the number.

4. IMPORTANT!!! Share the link as a link that has to be copied.

Click on the Share button

Open up a new tab and paste the link into that tab but DON'T HIT ENTER.

Change the word edit to the word copy.

https://docs.google.com/spreadsheets/d/2RETnl4UuE0qnWOf4IPXqdT4w6cGtTR4UuogCINTuYRQ/edit?usp=sharing

becomes

https://docs.google.com/spreadsheets/d/2RETnl4UuE0qnWOf4IPXqdT4w6cGtTR4UuogCINTuYRQ/copy?usp=sharing

The link with the word COPY in it is the one that you will link to your main project image. This will force people to make a copy of your spreadsheet.

Save the link and embed it into your main image.