A: The beginning of the year is full of data collection and there are countless opportunities for teachers to use conditional formatting to add a visual element to the data analysis process. Google Sheets offers many of the same conditional formatting options that you would find in MS Excel; however, if you like to use symbols and icons instead of text and background color, you might be disappointed with Google's offerings.
To demonstrate the process, I recorded myself applying some conditional formatting rules to a couple of authentic data sets.
- Highlight the cell or range of cells that you want to apply formatting rules to.
- Click the Format menu and select Conditional formatting….
- In the window that appears, define the conditions for specific text colors and/or cell background colors.
- Click Save rules.
You can apply multiple rules and select up to five for a given cell or range. To remove a rule, just click the "X" to the right of that rule.
- When you specify multiple rules, they are evaluated in the order listed. This means that the first rule found to be true will define the format of the cell or range.
- If you copy and paste from a cell or range that has formatting rules, these rules will be applied when you paste the copied data.
- There are no rule limits per cell or range in the new Google Sheets.
Google Sheets Help Site.