Conditional formatting is a truly remarkable feature of the modern spreadsheet program, exemplified by Microsoft Excel. In the decade since the first publication on conditional formatting in this journal, and with the singular exception of articles in Spreadsheets in Education, we note that this capability of Excel is still not cited much in the mathematics education literature. The present paper is written to review and summarize published accounts over the past decade and then to showcase basic and more advanced uses of conditional formatting in the hope that more mathematics educators will take the time to master this powerful tool for the benefit of their students.

Distribution License

Creative Commons License
This work is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 4.0 License.

Conditional Formatting 2.1.xlsx (48 kB)
Revised examples from paper