Google Sheets: Valentine’s Day Activity

Posted on February 9, 2019 by jgvadnais

Inspiration

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:
    February 10, 2019 at 11:27 am

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

    Like

    Reply
  3. Hope Albright says:
    February 10, 2019 at 4:54 pm

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

    Like

    Reply
  4. Michelle Fikac says:
    February 11, 2019 at 11:28 am

    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.

    Like

    Reply
  5. Riley Vadnais says:
    August 5, 2019 at 6:50 am

    ❤️

    Like

    Reply

Leave a reply to Hope Albright Cancel reply