One Advantage to Using Google Sheets Conditional Formatting…

I’m a visual learner and like using conditional formatting to add color to Google Forms Spreadsheets. The Google Form Spreadsheet collects the data obtained from a Google Form. Thanks to the colorization capability of spreadsheets I can start accessing the data before creating charts and using equations.

SPREADSHEET EXAMPLE OF USING CONDITIONAL FORMATTING TO COLLECT DATA
Conditional Formating Data

  1. The color options for each column was created by using conditional formatting
    1. Allows one to set colors based upon the answers
    2. Spreadsheet automatically colors cell depending on response
  2. Data information can be seen before charting or using equations
    1. Example from the above graphic
      1. More females answered the question
        1. Female represented by pink
        2. Milk chocolate was the most popular answer ~ light brown cells
        3. White Chocolate was the least favorite ~ Black cells
        4. Grade column is difficult to assess visually ~ no color added

HOW TO SET COLOR USING CONDITIONAL FORMATTING 

  • Create a Google Form with multiple choice, checkboxes or list questions
    • This is the easiest questions to use for conditional formatting
  • Open the response spreadsheet associated with the form
  • WATCH this Video to setup a conditional format for each spreadsheet column

https://youtu.be/Zq7-X3WCd5M

Advertisements

Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s