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