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

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