Suggestions for Conditional Formatting section of "Basic Quality Assurance and Control, and Data Manipulation in Spreadsheets"

[sararasmussn]

For the episode "Basic Quality Assurance and Control, and Data Manipulation in Spreadsheets", I would suggest these edits to the Conditional Formatting section:

• This subsection opens with, "Use with caution!" but does not elaborate why. I would suggest adding context on which situations this is an appropriate tool, and which it is not.
• From my own experience teaching with Excel/Calc/Google Sheets is that if learners know this tool, they use it a lot. They would benefit from the "why" - that it's a great tool for in-process diagnosis, but isn't a long-term solution, because certain colors cannot be seen by everyone, etc.
• Some of the "why" is already in the exercise section, so perhaps this could be moved up into the opening paragraph: "It is nice to do be able to do these scans in spreadsheets, but we also can do these checks in a programming language like Python or R, or in OpenRefine or SQL."

Thanks for your consideration!