The more I use Google Sheets, the more I love it.Especially within an educational setting, Google Sheets is a great tool to use when analysing data or simple representing your findings in a visually pleasing way.With the many options such as Charts and Tables available online through GAFE(Google Apps For Education), collaboration of students becomes the norm and they can easily present their work without having to worry about saving, sharing files and/or having old or conflicting copies of the same file.
In this 4th Short tutorial I have a look at another of those Great tools withing Sheets called ‘Conditional Formatting’.
Simply put: conditional formatting looks at the values in selected cells, and then applies a font and or background colour to this cell according to set ‘rules’.