Google Sheets isn't just for spreadsheets — with a little conditional formatting, it becomes a flexible, self-grading worksheet builder. Type a wrong answer and nothing happens. Type the exact right answer, spacing and punctuation included, and the cell turns red to confirm it. This video walks through four activity types you can build into one sheet, and four different ways to get that sheet in front of students.

Why use this tool?

Most worksheets only work one way. This one works four ways: live in Google Sheets, downloaded as a Microsoft Excel file, printed as a PDF, or handed out on paper. Build it once, and every student can use it in whatever format suits them.

It's also self-grading. Because the formatting is conditional on an exact match, students get instant feedback — right or wrong, no ambiguity. That instant confirmation keeps them engaged and lets them self-correct without waiting on a teacher to check their work.

Beyond convenience, this format supports inductive learning. Instead of being told a grammar rule up front, students test out answers, notice what turns red and what doesn't, and work out the pattern themselves through trial and error.

Four activity types on one sheet

Each activity uses the same core trick — conditional formatting that only turns a cell red on an exact match — but applies it differently:

1. Sentence jumble

Students see a jumbled set of words (e.g. "many is sold this product in stores") and must type the correctly ordered sentence, punctuation included. Miss the period or misspell a word, and the cell won't change color — pushing students toward precision.

2. Error correction

A sentence with a mistake is shown above two boxes: one for identifying the mistake, one for writing the correction. For example, "most food products are not grow here" — students type "grow" in the mistake box, then "grown" in the correction box. This works especially well when you pull real sentences from student writing and have them fix their own errors.

3. Vocabulary fit (semantics)

Students are given a sentence with a blank and a list of words that are all grammatically correct but not all correct in meaning. They type Y or N next to each option to mark whether it fits. This is a task type that rarely shows up in textbooks, and it pushes students to think about meaning rather than just grammar.

4. Q&A matching (pragmatics)

Students match a set of questions to the best response by typing the question number next to its matching answer. This works well as a lead-in to speaking practice or class discussion.

How to use it

Set up the worksheet in Google Sheets first — it tends to produce more consistent formatting than starting in Excel, since there's less chance of glitches from different OS versions or Excel builds. From there:

1. Build your prompts and answer key in separate cells, then apply conditional formatting rules so each answer cell changes color only on an exact text match.
2. Test each item yourself by typing near-correct and correct answers, to confirm the formatting only triggers on the precise answer.
3. Share it online by giving students edit access, or letting them import their own copy into their Drive.
4. Distribute it another way if needed — go to File > Download to save it as a Microsoft Excel file, or use Print (Cmd/Ctrl+P) to export it as a PDF for a paper-based version.

The same worksheet can move between Google Sheets, Excel, and even LibreOffice without breaking — build it once, then reuse it in whichever format the moment calls for.