Conditional Formatting

As human beings we are very visual learners. Our brains are designed to identify and group data based on visual cues like color. That makes color and color coding an important part of data analysis and Google Sheets. Inside of Google Sheets there is a feature called Conditional Formatting that allows the user to specify different criteria for the data and have the spreadsheet automatically update the colors and formatting of a cell automatically when these criteria are met. This allows the user to quickly and easily scan a document for important information. In this video, you will get introduced to conditional formatting in Google Sheets and learn the different options to update cells based on different criteria. This video was created in relation to the Utah State CTE standards for the Business Office Specialist High School course. Specifically, this video prepares students to complete Strand 2, Standard 3: Customize formatting and layout options within a workbook/worksheet. This video uses the Conditional Formatting workbook which you can copy by clicking the link below if you want to follow along. https://docs.google.com/spreadsheets/d/15FZqGYsAaku1RicYkSNtIKldpX75vr7f-0m10vHVP28/copy If you want to follow along with the Paint By Number activity, here are the Conditional Formatting rules in order: 1. Single Color rule where cells whose text contains the number 1 has a fill color of Black. 2. Single Color rule where cells whose value is greater than 50 has a fill color of Light cornflower blue 3. 3. Single Color rule where cells whose value is between 22 and 30 has a fill color of Light green 3. 4. Single Color rule where cells whose value is between 32 and 50 has a fill color of Light orange 1. 5. Single Color rule where cells whose value is less than 0 has a fill color of Light magenta 3.