Google Sheets: Valentine’s Day Activity


I’ve created several hidden number pictures using the conditional formatting feature within Google Sheets. One of the teachers I work with wanted to learn how to create her own designs.  This activity is the result of the training session.

The Hidden Picture

When you click to make your copy, this snapshot is what you’ll see.  A framed box holding the hidden picture is on the left and a question and answer section on the right.  When a correct answer is entered the reddish color turns green and the corresponding cells begin to reveal a picture.  Click here for your own copy

Screen Shot 2019-02-09 at 4.33.49 PM

Screen Shot 2019-02-09 at 4.35.00 PM


Screen Shot 2019-02-09 at 4.37.32 PM


About jgvadnais

Instructional Technology Coach. Desmos Fellow. Google Level 1 Certified. SoCal transplant. New Englander at heart. Lover of yoga, dogs, green smoothies and coffee creamer
This entry was posted in Google, google apps, Uncategorized and tagged , , , , , , , . Bookmark the permalink.

8 Responses to Google Sheets: Valentine’s Day Activity

  1. Pingback: All Circle Angles (Day 2) – When Math Happens

  2. Rima says:

    how did you do it? is any video showing the process?


  3. Hope Albright says:

    How do you do this????? This is amazing! Would you be willing to give a step by step!


  4. Michelle Fikac says:

    I’m trying to figure this out. I have a first grade teacher who would like to try this with her littles. Can you please teach me your ways.


  5. Riley Vadnais says:



Leave a Reply to Rima Cancel reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s